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

249 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
dirts6682446(None) 
airts55626341airts
darts67635731darts
diets66026641diets
dints67431311dints
dirks105619521dirks
dirls64720501dirls
dirt55550381dirt_
dirty95617801dirty
dits56450521di_ts
girts65423621girts
adits66523712adi_ts
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
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
dart55857872dart_
dauts67822242dauts
dawts97216122dawts
debts86418372debts
deets65330242deets
deists74916432deists
delts65731792delts
dents65031802dents
derats74625062derats
derms85022892derms
dials64925342dials
dibs76233682di_bs
dices86434242dices
dicks125824692dicks
dicots94915792dicots
dicta84915632dicta
dicty115116292dicty
didos76820812didos
didst74619612didst
dies55653522di_es
diet57357532diet_
diffs126315482diffs
difs86027322di_fs
dights114016962dights
digits84114532digits
digs66036052di_gs
dikes105831332dikes
dills65530972dills
dimes85833042dimes
dims75435022di_ms
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042di_ns
dint56759052dint_
diols65521012diols
dips75536912di_ps
dipt77339322dipt_
diram84419472diram
dirams94413702dirams
dire56644142dir_e
directs102710262directs
direr64927072direr
direst75024242direst
dirge75117072dirge
dirges84915102dirges
dirk96326832dir_k
dirl57430022dir_l
dirties83119382dirties
dis46459892di__s
discs85316262discs
disks105417472disks
diss56434482di_ss
dit47071332di_t_
dita56032522di_ta
ditas65923672ditas
dite55547552di_te
dites66339152dites
ditsy95612562di_tsy
ditto65315602ditto
dittos74111972dittos
ditty95019292ditty
ditz146929512di_tz
divas95418582divas
diverts114412032diverts
dives95832402dives
divots104712202divots
dixits144210312dixits
doats65224882doats
doits66223672doits
dolts65626312dolts
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
dorty96220812dorty
dots55647662d_ots
drats66628372drats
dribs85115062dribs
dries64733672dries
drifts10499892drifts
drips85417232drips
drys86314802d_rys
ducts85319892ducts
duets65323882duets
duits65021882duits
dunts65828412dunts
duras65727732duras
dures65635922dures
durns64819872durns
duros65422692duros
durrs65519992durrs
durst66125172durst
dusts65923562dusts
edicts94911702edicts
edits65819032edi_ts
farts88336842farts
fiats85324482fiats
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
first86226122first
firsts95110922firsts
firth115819532firth
firths125113502firths
fists85527542fists
fits76043462fi_ts
flirts95411482flirts
forts86034452forts
frits86129102frits
gifts96214962gifts
gilts64924262gilts
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girt56646422girt_
girth95618842girth
girths105612272girths
gists66026192gists
gits55744592gi_ts
grits65529582grits
harts88441592harts
hilts86924412hilts
hints87330622hints
hires86134342hires
hists86328372hists
hits75545132hi_ts
hurts86922822hurts
idiots768642idiots
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
odists749852odists
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.313570897.8
2DLD Change Limit538002491.64032804.9
3Display Results2492490.0633952.4
 (SQL Overall)1786912492.01688636.4
 
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.