Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “haboob” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

154 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
haboob137788(None) 
haboobs1495461haboobs
aboon74918702_aboon
baboo94319502baboo_
babool103012152babool
baboon103613912baboon
baboos103517012baboos
boob85932582__boob
cabob114616812cab_ob
gaboon93211772gaboon
hobnob1335132hobnob
kabob134113932kab_ob
nabob93913742nab_ob
taboo73418092taboo_
taboos83815432taboos
abbot9318453_abbot
abhor10411063_abhor
abloom1039783_abloom
abo59045963_ab_o_
abode85518813_abode
abohm1247973_abohm
aboil72217543_aboil
aboma91114603_aboma
abort76133583_abort
abos67734413_ab_os
about75229083_about
above105414323_above
absorb1038013_absorb
adobo84711593_adobo
afoot8420113_afoot
aloof83521573_aloof
babools11319453babools
baboons113211083baboons
bamboo12310013bamboo_
bamboos1348753bamboos
baobab946403baobab
bazoo163815673bazoo_
bazoos173212623bazoos
blob86027093__blob
bob76755673__b_ob
bomb106927423__bomb
boo58163663__boo_
boobs96221993__boobs
booby125319513__booby
book106836333__book
boom87435673__boom
boon67142173__boon
boor66130683__boor
boos67955033__boos
boot67759373__boot
cabobs124311893cabobs
cabomba1544083cabomba
caboose1138273caboose
cahoot11416473cahoot
carob95325223ca_rob
chabouk1844543chabouk
chapbook2193743chapbook
dahoon1039053dahoon
daybook1744373daybook
ebook114510803_ebook
gabion93211033gabion
gaboons10289903gaboons
galoot72719163galoot
gazoo153112873gazoo_
gazoos163010223gazoos
habile11515213habile
habit103027023hab_it
habits113014653habits
habu97325483hab__u
habus106317143hab_us
hadron102913753hadron
hagborn1344953hagborn
hagdon1188283hagdon
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
halloos103716743halloos
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
halo76437323ha_lo_
haloed104717603haloed
haloes94623863haloes
haloid104317763haloid
halon86124863ha_lon
halons95720713halons
halos85230253ha_los
hambone1439313hambone
handbook1844733handbook
hansom11219153hansom
hao67251123ha__o_
haole84820083ha_ole
harbor11410723harbor
harbors12412413harbors
harbour1247053harbour
hardboot1446943hardboot
harlot94422803harlot
harpoon1238313harpoon
harrow122610773harrow
hatbox1835133hatbox
havior1248203havior
havoc1337183ha_voc
havocs1435653havocs
haymow1773683haymow
hob87550923h___ob
hobnobs1443603hobnobs
hobo97026083hob_o_
hoboed124511683hoboed
hoboes114717443hoboes
hobos106321353hob_os
hood85132333h__ood
hoof106036583h__oof
hook116133283h__ook
hoop96129983h__oop
hoot75752103h__oot
hubbub1243603hubbub
jabot14321513jab_ot
jabots1538883jabots
kabab134814443kab_ab
kabobs14439303kabobs
karoo92519583karoo_
karoos102415803karoos
kazoo183311533kazoo_
kazoos19259113kazoos
kebob135110923keb_ob
labor75117313lab_or
labors84016413labors
labour84210933labour
lagoon7410483lagoon
lawbook1644033lawbook
maroon83118203maroon
nabobs10388213nabobs
racoon83814473racoon
ratoon64417373ratoon
rebook125213203rebook
reboot84119333reboot
rhabdom1543383rhabdom
sabot7931783sab_ot
sabots8314703sabots
saloon64418023saloon
saloop84212583saloop
seaboot9512333seaboot
shadoof1446133shadoof
tabooed10267383tabooed
tabor75518393tab_or
tabors84517113tabors
tabour84011323tabour
varoom11411413varoom
wahoo112413083wahoo_
wahoos122310593wahoos
wazoo173011173wazoo_
wazoos18288553wazoos
yahoo112911543yahoo_
yahoos12209243yahoos

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.376475242.0
2DLD Change Limit1127161545.36021029.1
3Display Results1541540.0463347.8
 (SQL Overall)1786911545.78230904.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.