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

190 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
abseil83718(None) 
abseils935971abseils
aboil72217542ab_oil
abseiled1144732abseiled
absent84016992absent
assail6610152assail
assoil688542assoil
basil75122272bas_il
abaci94718843abaci_
abase76023483abase__
abased96514993abase_d
abasedly1443343abasedly
abaser86414343abase_r
abasers95311973abasers
abases85720773abase_s
abasia8712953abasia
abatis84317933abatis
abaxial1646183abaxial
abaxile1644083abaxile
abbe87627193abbe__
abbes96723523abbe_s
abbess10509773abbess
abbey125714933abbe_y
abbeys13538423abbeys
abeam9316533ab_eam
abed79734133ab_e_d
abele76323253ab_ele
abelia83114403abelia
abet610547943ab_e_t
abets75621673ab_ets
abigail1044193abigail
abject17137703abject
able66340533able__
abled86926833able_d
ableism1136823ableism
ableist9311773ableist
abler75624313able_r
ables75935543able_s
ablest84721833ablest
aboral8314373aboral
abri65522213ab_ri_
abris75722603ab_ris
abs59356073abs___
abscess1133903abscess
abscise1145953abscise
abseiling1265343abseiling
absence1137713absence
absently1345813absently
absents93510723absents
absorb1038013absorb
abstain947253abstain
absurd935903absurd
abulia83512503abulia
abulic106411423abulic
abuse77119563abuse__
abused95614273abuse_d
abuser85413683abuse_r
abusers94710553abusers
abuses85119103abuse_s
abye97921003abye__
abyes105518533abye_s
abysmal1453973abysmal
abyssal1243763abyssal
agnail739533agnail
ail37171043a___il
ainsell796393ainsell
albeit8314343albeit
angel65019563ange_l
anil46437433a__nil
anneal64812293anneal
anvil82712603a_nvil
apneal83411123apneal
apneic1078623apneic
apostil947903apostil
appeal103911613appeal
appel94615893appe_l
apse67725383apse__
apses76823913apse_s
apsis75718293aps_is
archil11611573archil
areal55928733a_real
areic73219393a_reic
argil65116883a_rgil
ariel55228973arie_l
aril45843023a__ril
arse46539273arse__
arsenal739383arsenal
arsenic939323arsenic
arseno6318913arseno
arses55733873arse_s
arshin9312173arshin
arsis55722423ars_is
artel56122743arte_l
asci66519143a_sci_
asdic83814093a_sdic
asea46327183a_se_a
aspic95114733a_spic
aspis74618143a_spis
assai5711543assai_
assails769093assails
assais6711963assais
assent65119953assent
assert64922583assert
asses55629283asse_s
assess65710463assess
asset55932263asse_t
assets65617663assets
assoils776663assoils
astir55517093a_stir
aswirl935093a_swirl
aurei54821863aurei_
avail8313883a_vail
axel115222073a_xe_l
axil116424453a__xil
axseed1456993axseed
babel95821693babe_l
babesia1146623babesia
bagel85116793bage_l
bail65042803_b_ail
basal75722283bas_al
base64847023base__
based85331583base_d
basely114412313basely
baser74828923base_r
bases75644353base_s
basest84720493basest
basic96220523bas_ic
basils85717473bas_ils
basin75026923bas_in
basis75429863bas_is
bassi77019323bassi_
bastile9313913bastile
bel57148463_b_e_l
bell66237183_b_ell
bezil163812883_bezil
boil66335183_b_oil
brail75525553_brail
broil74918223_broil
caseic103212373caseic
casein83216453casein
ceil65725063__ceil
damsel9148033damse_l
deil56231623__deil
distil73616433distil
dossil75110903dossil
easel54521113ease_l
fossil9379353fossil
fusel85218493fuse_l
fusil84715323fus_il
hansel95214373hanse_l
hassel95614213hasse_l
heil76328933__heil
hosel86024813hose_l
instil61111383instil
issei568573issei_
isseis638563isseis
label75019383lab_e_l
losel54419423lose_l
nisei54214353nisei_
niseis63512023niseis
obeli73711933ob_eli
obsess845943obsess
ossein636593ossein
ousel55222403ouse_l
passel85117003passe_l
pastil85018323pastil
pistil83915073pistil
resail64418733resail
reseal64819643reseal
resell64215203resell
sail45447163__sail
sansei63411903sansei_
sanseis73011603sanseis
seal45654373__seal
seel45042983__seel
sei36048933__sei_
seif75638733__seif
seis45542393__seis
sel38253323__se_l
sell45840613__sell
soil46138833__soil
speil75618643_speil
subsoil967293subsoil
tahsil936343tahs_il
tassel66014773tasse_l
unseal63315473unseal
unsell63512543unsell
unveil957343unveil
veil75523593__veil
wassail1056133wassail

Search took 8 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.763234195.3
2DLD Change Limit1127161907.03316026.7
3Display Results1901900.0633015.9
 (SQL Overall)1786911907.85922737.1
 
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.