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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

147 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
resit5424104(None) 
recit75235101recit
refit84230061refit
relit55340681relit
remit75737221remit
resat55139681resat
reset55051861reset
resid64124091resid
resift94017721resift
resin54131051resin
resist64524531resist
resite64128451resite
resits64725561resits
rest46459841res_t
bedsit9312842bedsit
befit105222662befit
beset76739132beset
besot76429712besot
best66355322bes_t
cesti75217422cesti
credit9315192credit
crest74632692cres_t
debit85727842debit
deist64633592deist
demit84832302demit
desist74818812desist
drest65530342dres_t
edit54934862_edit
emit65438412_emit
erst47436432ers_t
exit114428672_exit
feist86230072feist
fest74949442fes_t
gest56149132ges_t
heist87030912heist
hest75950772hes_t
jest116738502jes_t
jesuit1339582jesuit
legit61323502legit
lest46956322les_t
merit7339182merit
mesic93617862mesic
neist54628442neist
nest45548732nes_t
pest65555292pes_t
petit74332652petit
pewit104622792pewit
posit75833332posit
preset84430982preset
presift12312222presift
prest75736352pres_t
prosit85124592prosit
react74634332react
rebait8320402rebait
rebid85121352rebid
rebut75927382rebut
recite83625112recite
recits83621352recits
recti73619622recti
recut74729242recut
redia65524482redia
redid74922392redid
redip87816962redip
redipt94116742redipt
reedit7617222reedit
reemit8717222reemit
reest54938092reest
refits94017652refits
refix155212482refix
reft75141272re_ft
regilt71217492regilt
rei35647252re_i_
reif76937642re_if
rein46040892re_in
reis45343232re_is
rejig133810122rejig
reknit10312532reknit
relet54749822relet
relic74623362relic
relict83623902relict
relist64628412relist
remet74843722remet
remint85329972remint
remits85622942remits
remix145916552remix
remixt155014852remixt
renig64518912renig
renin54830032renin
rent46661242re_nt
reoil55321182reoil
repin75324702repin
reposit9315862reposit
repot75132622repot
rerig64018482rerig
res35565042res__
resaid74517082resaid
resail64418732resail
resaw84117252resaw
resay85320542resay
reseat64131492reseat
resect84424702resect
resee54336332resee
resent63833622resent
resets65427612resets
resew84519502resew
resh76523452res_h
reship11310672reship
reshot93519632reshot
reside74224932reside
resids74219152resids
resifts10378702resifts
resight11510642resight
resign74212582resign
resile64627672resile
resins64528772resins
resiny94617362resiny
resists74414922resists
resited85122422resited
resites74027792resites
resize154117722resize
resod64720052resod
resort65728612resort
resow88217242resow
respite9513032respite
resplit9310372resplit
respot83117632respot
rests54935872rests
result6318222result
ret35982832re__t
retia55326112retia
retie55735302retie
retint65633442retint
revet84938842revet
revisit10311372revisit
rewet85135152rewet
rewin85623962rewin
roset55945242roset
rosin55325312rosin
rust45544912rus_t
sit35877752__sit
test48651622tes_t
vest75743602ves_t
visit8320962visit
weskit1338342weskit
west75748082wes_t
wrest84925432wres_t
zest136035702zes_t

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.0931921408.6
2DLD Change Limit538001471.79629955.5
3Display Results1471470.0463195.7
 (SQL Overall)1786911471.93592346.8
 
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.