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

206 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
terms7552347(None) 
berms95323661berms
derms85022891derms
germs85118871germs
herms105626431herms
perms95524511perms
teams75726511teams
teems76019781teems
term66233151term_
terns55226871terns
therms115914871therms
arms66137492_arms
barms96128462barms
beams95328172beams
bergs84718042bergs
berks115423122berks
berm86732752berm_
berme96022942berme
bermes106023002bermes
ceres75540012ceres
ceros74726072ceros
corms95626222corms
deems85421772deems
derm76031892derm_
derma84918512derma
dermas94116812dermas
dermis94717162dermis
dorms85723832dorms
elms67322702_elms
ems56435492_e_ms
eras45441502_eras
ergs55523812_ergs
erns45428222_erns
eros45238452_eros
errs45622532_errs
ers36046282_er_s
farms106324952farms
fems96428702fe_ms
feres86038182feres
fermi103914162fermi
fermis114313502fermis
ferns85220082ferns
firms105217422firms
forms105327052forms
gems75329112ge_ms
germ75428962germ_
germy115113662germy
geums85414112geums
gorms85619592gorms
harms106829012harms
helms105619462helms
hems95534942he_ms
herbs105520502herbs
herds96424682herds
heres86245902heres
herls85226432herls
herm95636152herm_
herma105318882herma
herns84825582herns
heros84930862heros
hers75844872her_s
items7499612ite_ms
jerks166514892jerks
kerbs115013672kerbs
kerfs125413572kerfs
kermes124616122kermes
kermis124012392kermis
kerns94719562kerns
mems85931502me_ms
mercs96020452mercs
meres75143572meres
merks114722402merks
merls77423902merls
neems77316292neems
nerds65719252nerds
nerts55924982nerts
neums75414252neums
norms76019302norms
peres76246642peres
peris75537072peris
perks115325802perks
perm85834632perm_
perps95521482perps
pervs105117372pervs
reams75729622reams
rearms85114652rearms
rems66237722re_ms
seams75731662seams
seems75525022seems
seres55448892seres
serfs84922012serfs
sers45746652ser_s
serums83916302serums
sperms102512602sperms
steams84916902steams
stems75219952ste_ms
steres63929532steres
sterns64616752sterns
storms85814602storms
tams67247932t_ams
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
teaks94222902teaks
teals56234132teals
team66238652team_
tears55436462tears
teas45851492te_as
teats55636812teats
techs106915832techs
teds54932572te_ds
teels55726372teels
teem66132602teem_
teens56227482teens
tees45353582te_es
teffs115111732teffs
teggs74710742teggs
tegs56031492te_gs
teles54536002teles
tells55828942tells
telos55424522telos
tels46841692te_ls
temp85323332te_mp
temps95417132temps
tends65425582tends
tens45647412te_ns
tents56434212tents
tepas76521682tepas
terai53525482terai
terais64023502terais
terce75721842terce
terces83921412terces
terga63315642terga
termed94816702termed
termer85717252termer
termers95414502termers
termly1138432termly
termor84412512termor
termors94712772termors
tern46134802ter_n
terne56426152terne
ternes65422902ternes
terra54419652terra
terras63516952terras
terry84721872terry
terse55026822terse
tests56530192tests
teths85418512teths
tetras63017612tetras
tetris62816292tetris
tets45847452te_ts
tews76431642te_ws
texas126514932texas
texts125515042texts
tharms115712242tharms
theres96525472theres
therm106018022therm_
therme115814992therme
thermes126214612thermes
thermos124610752thermos
thrums11429122thrums
tiers55526522tier_s
tires55437492tires
tirls54519802tirls
tiros54524892tiros
toms68343492t_oms
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
trams75327672trams
trees55835762trees
treks96016852treks
tres46542902t_res
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
trims75021472trims
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623232turns
turps74918732turps
twerps11345152twerps
tyers86220052tyer_s
tyres84725232tyres
tyros85118592tyros
uterus639192uterus
verbs104614392verbs
vermes115019142vermes
vermis114214962vermis
verts85724732verts
warms107726852warms
worms105320752worms
xerus12313332xerus
yerks125416562yerks
zerks185113822zerks
zeros144918102zeros

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.0961861364.6
2DLD Change Limit538002061.60633499.4
3Display Results2062060.0633269.8
 (SQL Overall)1786912061.765101241.4
 
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.