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 “ababab” 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.

123 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
abaca95118042abaca_
abacas104414722abacas
abaka114313822abaka_
abakas123911742abakas
abaya104413172abaya_
abayas114011702abayas
abba810522642ab_ba_
abbas95918642ab_bas
anabas8314082anabas
atabal839742atabal
baba88828342_baba_
babas96325732_babas
baobab946402baobab
kabab134814432_kabab
aba512850953__aba_
abaci94718843aba_ci
aback134816173aba_ck
abacus10349763abacus
abaft10318063aba_ft
abamp11310603aba_mp
abamps1236253abamps
abas68642083__abas
abase76023483aba_se
abased96514993abased
abaser86414343abaser
abases85720773abases
abash106016513aba_sh
abasia8712953abasia
abasias9711013abasias
abatable1238023abatable
abate76627843aba_te
abated95918453abated
abater85518123abater
abates85825033abates
abatis84317933abatis
abator84512713abator
abaxial1646183abaxial
abbacy1536623abbacy
abbe87627183ab_b_e
abbes96723523ab_bes
abbey125714933ab_bey
abbot9318453ab_bot
abeam9316533ab_eam
abfarad1344223abfarad
aboma91114603aboma_
abomas101113583abomas
aboral8314373aboral
abroad9310943abroad
absorb1038003absorb
agama85815573agama_
agamas97413443agamas
agapae9388043agapae
agapai9456843agapai
airbag956963airbag
alba68328333a_lba_
albas75925393a_lbas
albata839333albata_
albatas938373albatas
ameba9312373ameba_
amebae1049633amebae
ameban1039093ameban
amebas10311453amebas
arabic10312733arabic
arable81821003arable
asana5315483asana_
asanas6514113asanas
atabals938413atabals
ataman81013063ataman
avatar937523avatar
baa510650423_ba_a_
baal67033113_ba_al
baas66844673_ba_as
babe86835813_bab_e
babel95821693_babel
babes95834113_babes
babka137812913_babka
babkas146010143_babkas
baboo94319503_baboo
babu85829223_bab_u
babul96317713_babul
babus95620333_babus
baby116723673_bab_y
balas76937213_balas
banal75925993_banal
baobabs1044443baobabs
barb85240063_ba_rb
barbal104016663barbal
basal75722283_basal
bazar163816003_bazar
bibb75819193_bib_b
blab86629133_b_lab
bubal94218213_bubal
bubba84311793_bubba
cabal95222153_cabal
cabala103516913cabala_
cabalas113516003cabalas
cabana103913563cabana_
cabanas112413033cabanas
cabob114616803_cabob
carabao1139673carabao
casaba1079263casaba_
casabas1139983casabas
kababs14409763kabab_s
kabaka11348503kabaka_
kabakas12367403kabakas
kabala124011553kabala_
kabalas133911063kabalas
kabar114815553_kabar
kabaya15387123kabaya_
kabayas16316803kabayas
kabob134113923_kabob
kebab134311993_kebab
labara83712893labara_
nabob93913733_nabob
nawab10810923_nawab
qabala17399193qabala_
qabalah21285033qabalah
qabalas18289503qabalas
rabat72832223_rabat
sabal75422483_sabal
sabbat10314713sab_bat
scarab10310063scarab
seabag938473seabag

Search took 7 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.1561145455.1
2DLD Change Limit1127161235.87319192.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.07529414.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.