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

97 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
sieve8491884(None) 
lieve86315471lieve
nieve85613181nieve
siege66718441siege
sieved104611441sieved
sieves93216001sieves
slieve9359271slieve
breve105317052breve
diene65720132diene
dive85634772di_ve
eve66331162__eve
five107629742fi_ve
give85829352gi_ve
grieve1047242grieve
hive106029672hi_ve
jive146123592ji_ve
keeve124512132keeve
liege65314432liege
liever94611862liever
live76540992li_ve
neve76224832_neve
niece74814502niece
nieves94311292nieves
peeve104915252peeve
piece96717992piece
reeve84121322reeve
reive85522942reive
riever94811652riever
rive75537722ri_ve
salve85022132salve
save75741362s_ave
scene77220572scene
scrieve12448332scrieve
see35772262s_e_e
seine55732872seine
seise54727852seise
seize143819502seize
seme65836652s_eme
sene46848052s_ene
sere46153472s_ere
serve85425962serve
seven84118312s_even
sever85426052s_ever
shave114425892shave
sheave124514002sheave
sheeve123412842sheeve
shelve124012762shelve
shive114423422shive
shove114421042shove
shrieve13417682shrieve
sice65545592si_ce
side55444482si_de
sidhe95315102sidhe
sidle65124032sidle
sieged85212712sieged
sieges73816832sieges
sieur5911892sieur
sievert10613292sievert
sike87138782si_ke
silva82714022silva
silvae92811092silvae
silver93815812silver
silvex16336722silvex
since75024172since
sine46560622si_ne
singe65731132singe
sipe67341042si_pe
sire46150412si_re
siree55238812siree
site47052412si_te
siver85728612siver
sixte126216582sixte
size135630962si_ze
skee85431472ske_e
skene96118122skene
skive124614112skive
slave84224032slave
sleave94714152sleave
sleeve93411592sleeve
slieves10378962slieves
soave84219052soave
soever94412092soever
solve85618942solve
stave85324992stave
steeve93710902steeve
stele55026842stele
stere55328542stere
stove85220252stove
suave83519872suave
suede64419752suede
swede94413202swede
swerve1256292swerve
sweven1235982sweven
swive115316192swive
thieve1235962thieve
vive105426622vi_ve
wive105931752wi_ve

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.313570897.8
2DLD Change Limit53800971.59333772.8
3Display Results97970.0166062.5
 (SQL Overall)178691971.92292971.4
 
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.