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

280 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
tings6532919(None) 
dings76331401dings
kings105825561kings
lings67135771lings
pings85830881pings
rings65029171rings
sings65532701sings
stings76220181stings
tangs65028341tangs
things104914281things
tines54848421tines
ting56139891ting_
tinge64626611tinge
tinges74722321tinges
tins45251301tin_s
tints56030921tints
tongs65928461tongs
tungs65520621tungs
wings95727241wings
zings154620891zings
actings104512462actings
agings86312672agings
ains46158882ain_s
antings85015582antings
bangs85627772bangs
beings94613032beings
bigs76235012bi_gs
binds86627472binds
bines76946792bines
binge85125512binge
binges93923122binges
bingo86020092bingo
bingos95514792bingos
bins66548242bin_s
bints76130182bints
biogs85016112biogs
boings96416872boings
bongs87828422bongs
brings94618432brings
bungs85323862bungs
cigs75625102ci_gs
cines75239682cines
clings95716212clings
dangs75623202dangs
digs66036052di_gs
dines66449152dines
ding66940952ding_
dinge75627302dinge
dinges83825422dinges
dingo74720792dingo
dingus83611842dingus
dingy105721262dingy
dinks105927952dinks
dinos65428062dinos
dins56652042din_s
dints67431312dints
doings84913182doings
dongs76525812dongs
dungs75821972dungs
dyings11478132dyings
eatings84616432eatings
engs56121392_engs
fangs96224072fangs
figs85332642fi_gs
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fin_s
flings106715282flings
gangs76222572gangs
gatings95212822gatings
gigs66631182gi_gs
ginks104319562ginks
gins55543952gin_s
goings84911522goings
gongs74921612gongs
hangs95726722hangs
hinds96721472hinds
hinge95323442hinge
hinges105121022hinges
hins76447992hin_s
hints87330622hints
hongs95126202hongs
icings9428452icings
iggs66612672_iggs
inks86926502_inks
inns46920932_inns
ins35945602_in_s
jigs126524762ji_gs
jingo134615212jingo
jinks165019332jinks
jinns126013842jinns
jins115635012jin_s
kiangs11378362kiangs
kinas95626912kinas
kinds106221812kinds
kines95039132kines
king95933652king_
kinks84926082kinks
kinos96626142kinos
kins85747902kin_s
liangs74410592liangs
lines57054572lines
ling57447962ling_
linga66820812linga
lingas75116562lingas
lingo66022102lingo
lingy96925132lingy
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
longs65527062longs
lungs65223882lungs
lutings83311052lutings
lyings10488502lyings
matings104516202matings
miggs96311372miggs
migs76935312mi_gs
minas75434112minas
minds85427122minds
mines75651952mines
mingy115520182mingy
minis75432982minis
minks115829272minks
mints76834042mints
minus75223932minus
nines55937342nines
oinks94819912oinks
outings84014752outings
pangs84628662pangs
pigs76634222pi_gs
pinas75434452pinas
pines76048862pines
ping75943592ping_
pingo87122712pingo
pingos95317672pingos
pinks115729382pinks
pins65558452pin_s
pints75936222pints
pongs85526342pongs
pungs85422222pungs
ratings84217402ratings
rigs55137592ri_gs
rinds64826142rinds
ring56541152ring_
rinks94827102rinks
rins46153192rin_s
rungs611819402rungs
signs65516322signs
sines55954822sines
sing57544172sing_
singe65731132singe
singes74326852singes
sinhs86719602sinhs
sinks95529182sinks
sins46755272sin_s
sinus55523852sinus
slings74618012slings
songs67725552songs
stangs75018162stangs
sting65330242sting_
stingo74212162stingo
stingos8459442stingos
stingy105213202stingy
stinks105616832stinks
stints65119762stints
strings84617132strings
swings104714452swings
tags55545232t_ags
tains54936322tain_s
taints64520532taints
takings124512562takings
tang56138662tang_
tanga64923682tanga
tango66921172tango
tangos74216302tangos
tangy94519932tangy
tanks94624732tanks
tans46154812tan_s
teggs74710742teggs
tegs56031492t_egs
teinds738262teinds
tends65425582tends
tenge65720432tenge
tens45647412ten_s
tents56434212tents
thing96622962thing_
thinks134613352thinks
thins85826322thin_s
thongs104611182thongs
thugs95611992thugs
ticks115823292ticks
tics65729632ti_cs
tides64830152tides
tidings93810252tidings
tiers55526522tiers
ties45248312ti_es
tiffs114414882tiffs
tikes95628902tikes
tikis95615972tikis
tiles55542102tiles
tilings84212792tilings
tills54631702tills
tils45739612ti_ls
tilts55325612tilts
times75630822times
timings10279302timings
tin36362172tin__
tinct76126232tinct
tincts84510802tincts
tine45855132tin_e
tinea54923152tinea
tineas64616472tineas
tined65434532tined
tinged84220792tinged
tingle74319052tingle
tingles83818312tingles
tingly103815962tingly
tinny85317652tinny
tint46758862tin_t
tiny76134632tin_y
tipis76019922tipis
tips66436762ti_ps
tires55437492tires
tirls54519802tirls
tiros54524892tiros
tis37056642ti__s
titis56023812titis
tits46145032ti_ts
togs57242432t_ogs
tones56048662tones
tong56434352tong_
tonga65619682tonga
tongas74315512tongas
tons46553052ton_s
tonus56324302tonus
trigs65423062trigs
trines64132562trines
trogs67022602trogs
trugs65516802trugs
tubings10336482tubings
tugs56231672t_ugs
tunas54224122tunas
tunes55332192tunes
tung55328162tung_
tuns45138662tun_s
twangs10358092twangs
twigs96911172twigs
twines94717272twines
twinge104210392twinge
twinges11409442twinges
twins85118982twin_s
tying96019832tying_
tynes85920302tynes
vangs96319582vangs
vigs85427272vi_gs
vinas85126342vinas
vines85137642vines
vinos84723072vinos
wigs84931252wi_gs
winds95425602winds
wines85546862wines
wing86339222wing_
wingy126521032wingy
winks125325432winks
winos84625042winos
wins75949172win_s
wrings104012972wrings
yangs95618692yangs
yins75335122yin_s
zigs145422792zi_gs
zincs165312932zincs
zines145232652zines
zing145728612zing_
zingy186516132zingy
zins135735002zin_s

Search took 2 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.0802233637.5
2DLD Change Limit538002801.73331044.4
3Display Results2802800.0634444.4
 (SQL Overall)1786912801.87695251.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.