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

92 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
speir7531536(None) 
spear75821061spear
speer74623901speer
speil75618641speil
speirs85013231speirs
spier75728031spier
aper66336232ape_r
asper75520432aspe_r
heir77523802_heir
keir86217882_keir
pair66031512_pair
pear69745232_pear
peer66238352_peer
pein65834942_pein
per56353092_pe_r
peri65636972_peri
pier66035302_pier
sabir75917002sabir
sear47353842s_ear
seer45547042s_eer
sei36048932s_ei_
seif75638732s_eif
seis45542392s_eis
sepia75318672sepia
sepic94617052sepic
ser36752402s_e_r
shear85424832shear
sheer84726892sheer
sheik122514662sheik
shier85428942shier
sieur5911892sieur
sir35746682s__ir
skein94814412skein
skier95119602skier
slier54827242slier
smear74416392smear
sneer54919952sneer
spail74921552spail
spait75631602spait
spar65433302sp_ar
speak114618672speak
spean74620512spean
spears84019472spears
spec85821972spe_c
specie10412222specie
speck135115652speck
specs96916672specs
sped76031492spe_d
speed85526622speed
speel74420762speel
speers85019952speers
speils84116222speils
speired103811102speired
speise84614252speise
speiss84311642speiss
spell75020302spell
spelt75430192spelt
spend85619332spend
spent75532832spent
sperm93216022sperm
spew95421872spe_w
spewer115112152spewer
spews105015922spews
spic85227432sp_ic
spied85427712spied
spiel74623912spiel
spiers84421742spiers
spies76037622spies
spik105419712sp_ik
spin66231302sp_in
spire75828692sp_ire
spirt75032952sp_irt
spiry105017352sp_iry
spit65545082sp_it
spiv95917792sp_iv
split75729012split
spoil75818652spoil
spoor75016352spoor
sprier84119062sprier
sprig85617742sprig
sprit76736402sprit
spur65321192sp_ur
stair54719942stair
steer55423862steer
stein54620542stein
stir45723252s_tir
suer45334032sue_r
super74924482supe_r
swear85316852swear
sweer84918572sweer
their85512152their
weir76019922_weir

Search took 3 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.310576422.6
2DLD Change Limit53800921.69031834.3
3Display Results92920.0303066.7
 (SQL Overall)178691922.03088025.1
 
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.