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

380 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
resifts1037870(None) 
presifts1366591presifts
resift94017721resift_
resists74414921resists
resits64725561resi_ts
desists83611722desists
presift12312222presift_
recits83621352reci_ts
redshifts1642572redshifts
refits94017652refi_ts
reifs84819092re_if_s
relicts94414592relicts
relists73817052relists
remints95117292remints
remits85622942remi_ts
reseats74319582reseats
resects94115592resects
resents74221222resents
resets65427612res_ets
resides84523282resides
resids74219152resi_ds
resifted12310152resifted
resights1246732resights
resigns83910962resigns
resiles74026542resiles
resins64528772resi_ns
resist64524532resist_
resit54241042resi_t_
resite64128452resi_te
resites74027792resites
resizes164216842resizes
resorts74817192resorts
respots92912762respots
rests54935872res__ts
results739832results
retints74717012retints
rifts85718642r__ifts
sifts84918922__sifts
assists738473assists
bedsits1037563bedsi_ts
befits114711503befi_ts
bemists113410703bemists
besets85718803bes_ets
besides104814533besides
besmuts1134683besmuts
besots86415453bes_ots
bests75932613bes__ts
cesiums1136303cesiums
clifts11519153_clifts
credits1039973credi_ts
cressets10309103cressets
crests85218703cres__ts
debits94214503debi_ts
deists74916433de_ists
delfts10439673de_lfts
delicts104012253delicts
delists84414173delists
demits94918073demi_ts
depicts12358463depicts
desalts839573desalts
deserts82513053deserts
designs9328313designs
desires81316133desires
desist74818813desist_
despots10319683despots
drifts10499893_drifts
edicts94911703_edicts
edits65819033_edi_ts
efts76519483_e__fts
elints65816423_elints
emits75421473_emi_ts
escots84211743_escots
evicts11368553_evicts
exists134710913_exists
exits125515913_exi_ts
eyelifts1462753eyelifts
feints94813873fe_ints
feists94915313fe_ists
fests85828043fes__ts
freshets14298673freshets
gests66028813ges__ts
gifts96214963__gifts
grifts104511683_grifts
hefts116218153he__fts
heists96814633he_ists
heriots10312063heriots
hests85829933hes__ts
insists739083insists
jests125922453jes__ts
jesuits1436323jesuits
lefts86517813le__fts
legists899593legists
legits71313003legi_ts
lesions73813873lesions
lifts85719063__lifts
merits8320873meri_ts
misfits12279663misfits
neifs85613043ne_if_s
nests55728003nes__ts
persists1049183persists
pests75933273pes__ts
pewits112810683pewi_ts
posits85718713posi_ts
predicts1339613predicts
presents103315643presents
presets94216423pres_ets
presides11414913presides
presifted1536873presifted
presorts105311683presorts
prests84021263pres__ts
racists92613323racists
rafts87820633r__afts
rapists92510753rapists
reacts83616603re_acts
realists83014843realists
rebaits9312573rebaits
rebids94015533rebi_ds
rebills93510623rebills
rebinds104511873rebinds
rebirth1244933rebirth
rebirths1343083rebirths
reboots93512093reboots
rebuffs1533403rebuffs
rebuts84015193re_buts
recants93217093recants
recasts93413533recasts
receipts1274693receipts
recepts113010263recepts
recipes113314463recipes
recit75235103reci_t_
recite83625113reci_te
recites93524583recites
recoats92616643recoats
recuts83817373re_cuts
redacts10510943redacts
redfins1139923redfins
redials84416883redials
redias74523603redi_as
redips93713843redi_ps
redipt94116743redipt_
redouts81411663redouts
redrafts1235603redrafts
redshift1544623redshift_
redshirts1342903redshirts
reedits8511743reedits
reefs85121663re_ef_s
reemits9611303reemits
reests64618893re_ests
refects124012743refects
refights1555883refights
refiles104122423refiles
refills103711423refills
refilms12347503refilms
refinds114512123refinds
refines105426343refines
refires104820313refires
refit84230063refi_t_
refixes174813173refixes
reflets103513153reflets
refs75732243re__f_s
reft75141273re__ft_
regents83416543regents
regilds996673regilds
regilt71217493regilt_
regimes104514743regimes
reginas85614063reginas
regions83613473regions
regius7311923regi_us
regives115014213regives
reglets83512983reglets
regrafts1235303regrafts
regrets83212923regrets
reheats104513523reheats
rehires105016113rehires
reif76937653re_if__
reifies104218283re_ifies
reify114814973re_if_y
reigns74811753re_igns
reinks105012153re_inks
reins56234563re_i_ns
reis45343233re_i__s
reives95723043re_ives
rejects163910693rejects
rejigs14368093reji_gs
reknits1137073reknits
reknots1136783reknots
relents74018503relents
relets64025673re_lets
relics84517903reli_cs
relict83623903relict_
reliefs10439433reliefs
reliers75519213reliers
relies65036423reli_es
relights1248053relights
relines75331323relines
relinks114510223relinks
relist64628413relist_
relit55340683reli_t_
relives104619443relives
relucts9369673relucts
remeets93712413remeets
remelts93511493remelts
remiges103015473remiges
reminds104614793reminds
remint85329983remint_
remises93423483remises
remiss84216353remi_ss
remit75737223remi_t_
remixes164313873remixes
remixt155014853remixt_
renests74014213renests
renigs74314593reni_gs
renins64526453reni_ns
rennets75212633rennets
rents55935183re__nts
reoils64516873reoi_ls
repaints1038483repaints
repasts93611933repasts
repeats94316053repeats
repents93717623repents
repines94927383repines
repins84924313repi_ns
replots93412633replots
reports94916213reports
reposits10310453reposi_ts
repots85621003re_pots
reprints1039903reprints
rerents73319423rerents
rerigs74014793reri_gs
rerises73525883rerises
resails74616743resails
resales74724903resales
resat55139683res_at_
resaws93713513res_aws
resays93714153res_ays
rescinds1136333rescinds
rescripts1374573rescripts
rescues9312753rescues
reseals73917663reseals
reseat64131493reseat_
reseaus74012153reseaus
resect84424703resect_
resedas839123resedas
reseeds84012333reseeds
reseeks11348623reseeks
resees63827483res_ees
reseizes1759853reseizes
resells73313203resells
resends83513713resends
resent63833623resent_
reset55051863res_et_
resews94814173res_ews
reshes94124363res_hes
reshines112615443reshines
reships1239863reships
reshoes102316033reshoes
reshoots11228413reshoots
reshot93519633reshot_
reshows132510453reshows
resid64124093resi__d
reside74224933resi_de
resided95217703resided
residents1038423residents
resider84615803resider
residers93311883residers
residua8286623residua
residue8689863residue
residues9338813residues
resifting133512093resifting
resight11510643resight
resign74212583resi_gn
resile64627673resi_le
resiled84621983resiled
resilin72913973resilin
resilins83013373resilins
resin54131053resi__n
resinate8316773resinate
resinates9314763resinates
resined84522653resined
resinous838503resinous
resiny94617363resi_ny
resisted9312693resisted
resister8311653resister
resisters9310453resisters
resistor847673resistor
resistors947993resistors
resited85122423resited
resize154117723resi_ze
resized174614903resized
reslate73520593reslate
reslates83619503reslates
resmelts1046143resmelts
resoaks1148973resoaks
resods74116303res_ods
resoften1145443resoften
resoftens1243713resoftens
resojets1535343resojets
resoles73823653resoles
resorbs95010523resorbs
resort65728623resort_
resows93915353res_ows
respects1247703respects
respires10311903respires
respite9513033respite
respites10513243respites
resplits1037723resplits
respot83117633respot_
rest46459843res__t_
restaffs1444783restaffs
restarts8310873restarts
restate73824883restate
restates83423433restates
resters74130403resters
restful1038623restful
restricts1138823restricts
restuffs1444193restuffs
result6318223result_
resumes9313373resumes
retests73813853retests
reties65436193reti_es
retiles74426993retiles
retimes95020173retimes
retinas74819353retinas
retines75134673retines
retint65633443retint_
retires74726213retires
retorts76016513retorts
rets45352563re___ts
retsinas8387963retsinas
retwists1135603retwists
reverts104715043reverts
revests104413733revests
revets94022173re_vets
reviews1335533reviews
reviles104421353reviles
revises104220533revises
revisits1137423revisits
revives134715543revives
revolts1038893revolts
revuists1135153revuists
rewets94617213re_wets
rewinds114810483rewinds
rewins95020823rewi_ns
rewires104717113rewires
rexines144719153rexines
riffs115114613r__iffs
rifs74929003r__if_s
rift75642333r__ift_
riots54922013r__iots
risings83211893risings
rosets65819953ros_ets
rosiest73919213rosiest
rosins64521863rosi_ns
russets738163russets
rusts55026993rus__ts
sealifts1135473sealifts
seifs85019333se_if_s
serifs94017053serif_s
sestets7911473sestets
sexists14267673sexists
shifts124412943_shifts
shrifts1335963shrifts
sift710740663__sift_
silts55330823__silts
sits45050203__si_ts
softs85019233__softs
swifts12408173_swifts
tests56530193tes__ts
thrifts1335523thrifts
unshifts1444033unshifts
uplifts12424773uplifts
upshifts1642633upshifts
verists103613673verists
vests85325983ves__ts
visits9311423visi_ts
wefts116715493we__fts
weskits1434743weskits
wests85727003wes__ts
wrests95313083wres__ts
zests145419743zes__ts

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit1340273806.09621986.1
3Display Results3803800.1402714.3
 (SQL Overall)1786913806.63926915.3
 
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.