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 “sabal” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
sabal7542248(None) 
cabal95222151cabal
sabals84618861sabals
salal55425701salal
sambal105215181sambal
aal39058672_a_al
aba512850952_aba_
abas68642082_abas
anal48037522_anal
atabal839742atabal
axal116520492_axal
baal67033112ba_al
baba88828352baba_
babas96325732babas
babel95821692babel
babul96317712babul
bal56662722__bal
banal75925992banal
barbal104016662barbal
basal75722282basal
bubal94218212bubal
cabala103516912cabala
cabals104020152cabals
canal75428042canal
fatal84819372fatal
gayal9312712gayal
hadal95518122hadal
halal85623592halal
hamal104623112hamal
jacal14313702jacal
kabab134814442kabab
kabala124011552kabala
kabar114815552kabar
label75019382label
labial84714342labial
nasal56217592nasal
natal53921492natal
naval85315832naval
papal95820672papal
pibal95217322pibal
qabala17399192qabala
rabat72832222rabat
ramal74622242ramal
ratal55025112ratal
sab56563202sab__
sabbat10314712sabbat
sabe66140572sab_e
sabed86526812sabed
saber75330242saber
sabes76437462sabes
sabin74924952sabin
sabir75917002sabir
sable74732162sable
sabot7931782sabot
sabra75317852sabra
sabras85116362sabras
sabre74821502sabre
sabs66643742sab_s
sacral83414412sacral
saga55331172saga_
sagas66025882sagas
sail45447162sa_il
sal36462882s__al
salad65321832salad
salals65120082salals
sall44544682sa_ll
salol55222142salol
samba95618772samba_
sambals115213482sambals
sambar103914162sambar
sambas104219262sambas
sandal73317282sandal
saran53730302saran
satay84718462satay
saul45836522sa_ul
seabag938472seabag
seal45654372s_eal
sepal77723002sepal
seral56336382seral
setal56430902setal
sheal84927702sheal
shoal83920272shoal
sial45938842s_ial
sibyl1037112sibyl
sisal54217732sisal
skoal93811462skoal
soba64927922soba_
sobas74424252sobas
statal61613222statal
steal56125472steal
suba64926602suba_
subah106015212subah
subas74724082subas
sural55931262sural
tabla73318362tabla
tamal73522622tamal
tubal75517202tubal
vagal94613632vagal
vasal85516292vasal

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit53800991.59633709.3
3Display Results99990.0303300.0
 (SQL Overall)178691991.92292971.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.