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

279 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
shrifts133596(None) 
shifts124412941sh_ifts
shrift12413541shrift_
thrifts1335521thrifts
drifts10499892_drifts
grifts104511682_grifts
rifts85718642__rifts
scripts11509372scripts
serifs94017052serif_s
shafts125411442sh_afts
sharifs13279902sharif_s
sheriffs17253922sheriffs
sherifs13299682sherif_s
shift114225142sh_ift_
shifty15409262sh_ifty
shirts94918342sh_irts
shists96515112sh_ists
shits84731172sh_i_ts
shrieks14377672shrieks
shrikes144412392shrikes
shrills10389932shrills
shrimps14516752shrimps
shrines104618692shrines
shrinks14397912shrinks
shris84221452shri__s
shrives134416172shrives
shroffs1634362shroffs
sifts84918922s__ifts
sprints94113772sprints
sprits85122532spri_ts
strifes104716582strifes
swifts12408172s_wifts
thrift12412042thrift_
thrifty1634192thrifty
adrift10313113adrift_
afrits9311903afri_ts
airlifts1143633airlifts
aorists74215833aorists
astricts1049463astricts
aurists74615783aurists
brits76433083_bri_ts
britts84813443_britts
chariots1339393chariots
chints115117833ch_ints
chits105424573ch_i_ts
chrisms1499143chrisms
christy1536623christy
clifts11519153_clifts
crafts115312743_crafts
crits75527573_cri_ts
crofts114910593_crofts
drafts105012533_drafts
drift95722843_drift_
drifty13418223_drifty
esprits938393espri_ts
forints10411833forints
frits86129103_fri_ts
fritts94613193_fritts
gifts96214963__gifts
grafts105013253_grafts
griffs13398993_griffs
grift95924463_grift_
griots74713643_griots
grists74716483_grists
grits65529583_gri_ts
hafts116219463_h_afts
haints94417583_haints
hefts116218153_h_efts
heists96814633_heists
heriots10312063heriots
hilts86924413_h_ilts
hints87330623_h_ints
hists86328373_h_ists
hits75545133_h_i_ts
hoists95516023_hoists
jurists14409123jurists
krafts13438853_krafts
lariats7615053lariats
lifts85719063__lifts
lyrists1036963lyrists
merits8320873meri_ts
prints84320103_prints
purists94014073purists
rafts87820633__rafts
resifts10378703resifts
riffs115114613__riffs
rifs74929003__rif_s
rift75642333__rift_
riots54922013__riots
sacrists1039563sacrists
sadists83310853sadists
saints65122423s_aints
sarins63932623sari_ns
saris54544953sari__s
schists1248543schists
schriks16185743schri_ks
schuits1235823schui_ts
scribes113713203scribes
scries85226823scri_es
scrimps13517903scrimps
scrims104615933scri_ms
scrips105316033scri_ps
script105717903script_
scrives124414273scrives
scruffs1554173scruffs
sealifts1135473sealifts
seifs85019333s_eif_s
serfs84922013ser_f_s
serials73919743serials
seriate73722473seriate
seriates82620673seriates
series64540973seri_es
serif84132133serif__
serifed11811463serifed
serines74229543serines
serins64029673seri_ns
serious73616283serious
sexists14267673sexists
shaft115725263sh_aft_
shairds11216263shairds
shairns10276783shairns
shariahs14206393shariahs
sharias102516003shari_as
sharif122917123sharif__
sheafs124912883sheaf_s
sheets93918503sh_eets
sheikhs17233993sheikhs
sheiks132510013shei_ks
sheilas1059403sheilas
sherbets1335213sherbets
sherif122915243sherif__
sheriff16287693sherif_f
sheroots1137863sheroots
shiatsu1033433sh_iatsu
shiels95418923sh_iels
shiers94921753sh_iers
shies86136553sh_i_es
shiest95821523sh_iest
shifted14359983sh_ifted
shifter132911083sh_ifter
shifters14319863sh_ifters
shills94519613sh_ills
shims104422553sh_i_ms
shines95028913sh_ines
shins85131043sh_i_ns
ships105123773sh_i_ps
shires95225573sh_ires
shirks134814123sh_irks
shirrs94413173sh_irrs
shirt84533903sh_irt_
shirty124312563sh_irty
shist84829613sh_ist_
shit76745943sh_i_t_
shitty124110063sh_itty
shivas124512413sh_ivas
shives124921413sh_ives
shivs115018803sh_i_vs
shoats94117083sh_oats
shoots94619363sh_oots
shoplifts1742763shoplifts
shorings12269483shorings
shorts95321743sh_orts
shots84730853sh__ots
shotts93614703sh_otts
shouts94017723sh_outs
shreds105613053shr_eds
shrews129313913shr_ews
shri76021703shri___
shriek134211103shri_ek
shrieky17364803shrieky
shrieve13417683shrieve
shrieves14297093shrieves
shrike134513243shri_ke
shrill94712303shri_ll
shrilly13318563shrilly
shrimp13478773shri_mp
shrimpy17415403shrimpy
shrine94920053shri_ne
shrined114112413shrined
shrink134511733shri_nk
shrive125216953shri_ve
shrived144712183shrived
shrivel13479403shrivel
shrivels14376443shrivels
shriven13379653shriven
shriver134712193shriver
shrivers14419103shrivers
shroff1538503shrof_f
shrouds1136023shrouds
shrubs11409213shr_ubs
shrugs10469163shr_ugs
shticks16356963shticks
shtiks13297833shti_ks
shunts95712023sh_unts
shuts85622483sh__uts
sift710740663s__ift_
silts55330823s__ilts
sits45050203s__i_ts
skiffs16327013s_kiffs
skirts104111503s_kirts
skits94721863s_ki_ts
slits56128853s_li_ts
sniffs12378843s_niffs
snits54124833s_ni_ts
soffits1335093soffits
softs85019233s__ofts
sorbets93012513sorbets
sorings83817253sorings
sorites73825243sorites
sorts54536663sor__ts
soviets1087293soviets
spaits85017473spai_ts
spiffs14328473s_piffs
spirits94112623spirits
spirts85317133s_pirts
spits74429553s_pi_ts
spliffs1533563spliffs
splints94511743splints
splits85416413spli_ts
sprats85819933spr_ats
spriest92718643spriest
sprights14167143sprights
sprigs94814773spri_gs
springs104415923springs
sprint84526793sprint_
sprit76736403spri_t_
sprite84421773spri_te
sprites94220333sprites
spritz174714423spri_tz
sprouts949983sprouts
squints16339033squints
squirts16348013squirts
sris45434153s_ri__s
stiffs12389963s_tiffs
stilts67915313s_tilts
stints65119763s_tints
strafes104516003strafes
straits74916323straits
streets73312613streets
striata7379953striata
striate74218953striate
striates83417083striates
stricks134310693stricks
strict84821043strict_
strides84520393strides
strife95318363strif_e
strikes114719093strikes
strings84617133strings
stripes95320573stripes
strips85719653stri_ps
stript85222193stript_
strives104119373strives
strunts7429543strunts
struts65616803str_uts
suints64617783s_uints
suits55028053s_ui_ts
surfs85022543sur_f_s
surimis938843surimis
swift116818053s_wift_
tariffs1334593tariffs
thefts12387923th_efts
theists1039153theists
thirsts1036243thirsts
threats104311673threats
thrills10398783thrills
thrips11299013thri_ps
thrives134611713thrives
throats104612193throats
thrusts10226523thrusts
tsarists857303tsarists
unshifts1444033unsh_ifts
uplifts12424773uplifts
upshifts1642633upsh_ifts
verists103613673verists
whiffs1835083wh_iffs
whists124613813wh_ists
whits115923823wh_i_ts
wrists95415643_wrists
writs86624383_wri_ts

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 Filter1786911340270.1431249587.4
2DLD Change Limit1340272797.48317910.9
3Display Results2792790.0933000.0
 (SQL Overall)1786912797.71923149.5
 
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.