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

216 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
girts6542362(None) 
airts55626341airts
dirts66824461dirts
gifts96214961gifts
gilts64924261gilts
girds74816991girds
girls64518391girls
girns64516801girns
giros65722651giros
girt56646421girt_
girth95618841girth
girths105612271girths
gists66026191gists
gits55744591gi_ts
grits65529581grits
agists75713172agists
airns55521032airns
airs46447422air_s
airt45757782airt_
airth85621022airth
airths95414252airths
aits46355532ai_ts
arts49650262_arts
bints76130182bints
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
birth105619872birth
births115713602births
bits66148162bi_ts
bitts75022592bitts
borts76735452borts
brits76433082brits
carts78946292carts
cires74932912cires
cists76624532cists
crits75527572crits
darts67635732darts
diets66026642diets
dints67431312dints
dirks105619522dirks
dirls64720502dirls
dirt55550382dirt_
dirty95617802dirty
dits56450522di_ts
farts88336842farts
fiats85324482fiats
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
first86226122first
firsts95110922firsts
firth115819532firth
firths125113502firths
fists85527542fists
fits76043462fi_ts
flirts95411482flirts
forts86034452forts
frits86129102frits
gaits65726012gaits
garbs86321412garbs
gars55750742gar_s
garth94720222garth
garths104111502garths
gasts66628632gasts
gats56753442g_ats
gelts65924612gelts
gents65729612gents
germs85118872germs
gests66028812gests
gets55442482g_ets
ghats95818612ghats
giants74713502giants
gibes84422522gibes
gibs75529272gi_bs
gids65933742gi_ds
gies55641422gi_es
gift86735792gift_
gigas75415582gigas
gigots83911952gigots
gigs66631182gi_gs
gilds75417522gilds
gills64728192gills
gilt56348542gilt_
gimps105915202gimps
ginks104319562ginks
gins55543952gi_ns
gips75632922gi_ps
gird65424992gir_d
girl56226552gir_l
girly94415292girly
girn56026862gir_n
giro55828632gir_o
giron66118992giron
girons75014372girons
girsh95310022girsh
girted83912872girted
gist56046762gist_
git46266052gi_t_
gite55438612gi_te
gites65630182gites
gives95324872gives
glints75714212glints
gluts66120132gluts
gnats65217712gnats
goats65527302goats
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gouts64826172gouts
grids75321392grids
grifts104511682grifts
grigs75318192grigs
grins65427222grins
griots74713642griots
grips85520132grips
grist65529872grist
grists74716482grists
grit55247242grit_
grith95520372grith
griths105211652griths
grots65025852grots
guilts74111232guilts
guiros7389092guiros
gurus64318192gurus
gusts65722792gusts
guts56637252g_uts
gyres94820322gyres
gyros95616482gyros
gyrus95310802gyrus
harts88441592harts
hilts86924412hilts
hints87330622hints
hires86134342hires
hists86328372hists
hits75545132hi_ts
hurts86922822hurts
ires45639282_ires
iris45732552_iris
irks86220132_irks
its35538832_i_ts
jilts124717412jilts
karts97630112karts
kilts95122182kilts
kirks84915262kirks
kirns95315452kirns
kirs85831742kir_s
kists95822112kists
kits86441772ki_ts
lifts85719062lifts
lilts55822802lilts
lints57137192lints
liras56021982liras
lists56628692lists
lits46252492li_ts
marts77442232marts
milts75430712milts
mints76834042mints
mires75640882mires
mirks115122142mirks
mirs66940572mir_s
mirth106418892mirth
mirths114912992mirths
mists76633902mists
mitts75523752mitts
morts75533562morts
nerts55924982nerts
nits45741642ni_ts
orts46538332_orts
parts77743372parts
pints75936222pints
pirns76020092pirns
pits66348742pi_ts
ports75934592ports
quirts154213552quirts
rifts85718642rifts
riots54922012riots
shirts94918342shirts
sifts84918922sifts
silts55330822silts
sires55945372sires
sirs44338332sir_s
sits45050202si_ts
skirts104111502skirts
sorts54536662sorts
spirts85317132spirts
tarts57242022tarts
tilts55325612tilts
tints56030922tints
tires55437492tires
tirls54519802tirls
tiros54524892tiros
tits46145042ti_ts
torts56138122torts
verts85724732verts
vires84529682vires
virls85618602virls
virtu85314092virtu
virtus94310142virtus
virus85316842virus
warts814840402warts
wilts85023502wilts
wires86034912wires
wists86728522wists
wits76044872wi_ts
worts88631182worts
writs86624382writs
yirds96612512yirds
yirrs8469192yirrs
yirth116513752yirth
yirths12639532yirths
yurts87216532yurts
zits136030292zi_ts

Search took 3 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.310576422.6
2DLD Change Limit538002161.70331591.3
3Display Results2162160.0633428.6
 (SQL Overall)1786912162.07686074.7
 
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.