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

297 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
thrift1241204(None) 
shrift12413541shrift
thrifts1335521thrifts
thrifty1634191thrifty
adrift10313112adrift
drift95722842_drift
grift95924462_grift
rift75642342__rift
shift114225142sh_ift
shrifts1335962shrifts
tariff12711362tariff
theft114118132th_eft
theist9314762theist
thirst9312252thirst
threat95020462threat
thrice114311572thrice
thrill94910592thrill
thrip103012182thri_p
thrips11299012thrips
thrive125313222thrive
throat94819752throat
thrust91911892thrust
aerify122810113aerify
afrit8323173afri_t
airlift1048583airlift
aorist64827873aorist
atheist10314063atheist
athirst1037873athirst
attrit6315753attri_t
aurist65027253aurist
bereft114317303bereft
brit66350153_bri_t
britt75732233_britt
chariot12316213chariot
chit96937463ch_i_t
chrism13710673chrism
christy1536623christy
clift106422193_clift
craft105327663_craft
crit65743713_cri_t
croft105622683_croft
draft95526683_draft
drifts10499893_drifts
drifty13418223_drifty
dript86923873_dript
etherify1744443etherify
forint9325023forint
frit77044473_fri_t
fritt86129413_fritt
gift86735803__gift
graft95327203_graft
griff124416463_griff
grifts104511683_grifts
griot65328413_griot
gript85126173_gript
grist65529873_grist
grit55247243_gri_t
haft105941843_h_aft
haint85436323_haint
heft106736293_h_eft
heist87030913_heist
heriot9422343heriot
hilt75850723_h_ilt
hint77455753_h_int
hist76551553_h_ist
hit66569203_h_i_t
hoist86433213_hoist
jurist134616393jurist
kraft125721013_kraft
lariat6629053lariat
lift76942733__lift
lyrist9312293lyrist
merit7339183meri_t
print74837463_print
purify14399153purify
purist85525053purist
raft76245913__raft
rarify123210063rarify
reft75141273__reft
resift94017723resift
rif65951573__rif_
rife74632333__rife
riff104430113__riff
rifs74929013__rifs
rifts85718643__rifts
riot45947223__riot
script105717903script
serif84132133serif_
serifs94017053serifs
shaft115725273sh_aft
sharif122917123sharif_
sharifs13279903sharifs
sherif122915243sherif_
sheriff16287693sheriff
sherifs13299683sherifs
shifts124412943sh_ifts
shifty15409263sh_ifty
shirt84533903sh_irt
shist84829613sh_ist
shit76745943sh_i_t
shri76021703shri__
shriek134211103shriek
shrike134513243shrike
shrill94712303shrill
shrimp13478773shrimp
shrine94920053shrine
shrink134511733shrink
shris84221453shri_s
shrive125216953shrive
shroff1538503shroff
sift710740673__sift
sprint84526793sprint
sprit76736403spri_t
strict84821043strict
strife95318363strife
stript85222193stript
swift116818053_swift
tacit76333673taci_t
taint55542283t_aint
tanist6324613tanist
target75028913target
tariffs1334593tariffs
taring73932283taring
tarot55943933tar_ot
tart47566183tar__t
tercet83624913tercet
terret63425623terret
terrify1336353terrify
territ63421383territ
thairm1156963thairm
that75639323th__at
thefts12387923th_efts
thein85919023thei_n
theine94814923theine
theins95015423theins
their85512153thei_r
theirs94610353theirs
theism1139483theism
theists1039153theists
theorist1149553theorist
thereat104315243thereat
theriac1239143theriac
therian10311293therian
thermit12312013thermit
thick145613353th_ick
thief114516303th_ief
thigh12410123th_igh
thill85918733th_ill
thin76732393th_i_n
thine85026863th_ine
thing96622983th_ing
think125018803th_ink
thins85826333th_ins
thio77225413th_i_o
thiol87616043th_iol
thir76420543th_i_r
thiram1139963thiram
third95912493th_ird
thirds10438603thirds
thirl85416823th_irl
thirls95012063thirls
thirsts1036243thirsts
thirsty1354083thirsty
thirty12378403thirty
this76027383th_i_s
thoria93012893thori_a
thorias102312053thorias
thoric114314043thori_c
thorite10313443thorite
thorium12208413thorium
thrall93810293thrall
thrash12258363thrash
thrave126010273thrave
thraw1110515923thr_aw
thrawn12769423thrawn
thraws129211103thraws
thread105011093thread
threap11569663threap
threats104311683threats
three87526913thr_ee
threep115910113threep
threes97117323threes
thresh12276863thresh
threw1117315713thr_ew
thriftier1542853thriftier
thriftily1842003thriftily
thrills10398783thrills
thrived14458183thrived
thriven13447023thriven
thriver13479123thriver
thrives134611713thrives
thro77726423thr__o
throats104612193throats
throaty13428483throaty
throb109816853thr_ob
throbs118311373throbs
throe89321423thr_oe
throes97518673throes
throne98517603throne
throng10539973throng
throve128012393throve
throw118719733thr_ow
thrown1214911443thrown
throws129715233throws
thru76818943thr__u
thrum104713633thr_um
thrums11429123thrums
thruput1243863thruput
thrush12257483thrush
thrusts10226523thrusts
thurifer1443273thurifer
thwart12311683thwart
tiff104727733t__iff
tilt46252433t__ilt
tint46758873t__int
tiring74023093tiring
tit36771063t__i_t
toft77441653t__oft
toit46353063t_oi_t
tori47542153tori__
toric76529313tori_c
torics85118353torics
tories65435883tories
torii55521593tori_i
torot56139943tor_ot
torrify1335013torrify
tort46967463tor__t
tourist7313203tourist
tract75635713t_ract
trait56940843t_rait
trapt76433393t_rapt
treat56240353t_reat
tref77030993t_ref_
tret46653533t_r_et
triac74116373t_riac
triad65217723t_riad
trial54926353t_rial
tribe74420273t_ribe
trice75127493t_rice
trick115420693t_rick
tricot8317753t_ricot
tried65026913t_ried
trier54328533t_rier
tries55742813t_ries
trifid1039063t_rifid
trifle94012883t_rifle
trig55528163t_ri_g
trigo65716053t_rigo
trigs65423063t_rigs
trijet133916553t_rijet
trike95320163t_rike
trill55122933t_rill
trim65329523t_ri_m
trims75021473t_rims
trine54734603t_rine
trio45233343t_ri_o
triol55521363t_riol
trios55528093t_rios
trip66830393t_ri_p
tripe75425383t_ripe
trips74923363t_rips
triste63818643t_riste
trite54730033t_rite
trivet93721883t_rivet
trot46351313t_r_ot
trout57332573t_rout
trust55426853t_rust
tryst84716223t_ryst
tsarist7712253tsarist
tubist83013163tubist
tuft76929513t__uft
turbit8715113turbit
turbot8914263turbot
turf75334053tur_f_
turfs84620443tur_fs
turfy114315403tur_fy
turion6313163turion
turista737443turista
turret63121853turret
twist86820983t_wist
twit76329063t_wi_t
twixt155512483t_wixt
typify1734523typify
typist1139823typist
tyrant9315333tyrant
tyring104613023tyring
tzarist1659103tzarist
unthrifty1881723unthrifty
uplift114610653uplift
verify153110163verify
verist93823893verist
whiff17310063wh_iff
whipt135317423wh_ipt
whist115322953wh_ist
whit104834173wh_i_t
wrist84827563_wrist
writ75537913_wri_t

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162976.40617595.4
3Display Results2972970.1062801.9
 (SQL Overall)1786912976.90225889.7
 
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.