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

205 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
dorrs6552059(None) 
doers65225711doers
doors65022131doors
dorks105724441dorks
dorms85723831dorms
dorps85419221dorps
dorr56627721dorr_
dors56747601do_rs
durrs65519991durrs
torrs53923561torrs
adorers84411722adorers
adores74420712adores
adorns74212612adorns
birrs74917102birrs
boars75229602boars
boors74325012boors
boras75938302boras
borers85122682borers
bores76448252bores
borks115727702borks
borts76735452borts
burrs74925652burrs
carrs75730852carrs
coirs75221052coirs
cords86030622cords
corers85231072corers
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442co_rs
currs75624392currs
darbs85323262darbs
darers75921872darers
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
dears65736882dears
deers64930522deers
derms85022892derms
derris73615272derris
derry94721372derry
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
doats65224882doats
dobra85013102dobra
dobras94811912dobras
dobro84412212dobro
dobros93910232dobros
docks126022312docks
docs75631152do_cs
dodos75819392dodos
doer57734702doer_
does56554472do_es
doffs125614332doffs
doges75630162doges
dogs66440152do_gs
doits66223672doits
dojos135111792dojos
doles67843752doles
dolls66126922dolls
dolors75115312dolors
dols56943052do_ls
dolts65626312dolts
domes85735562domes
doms76239572do_ms
donas65926472donas
dongs76525812dongs
donors75115792donors
dons56048702do_ns
dooms85321342dooms
door56928512door_
dopas85019062dopas
dopers95522482dopers
dopes84935042dopes
dor47253922do_r_
dore56353302do_re
dories75232362dories
dork96531462do_rk
dorky135518742dorky
dorm76834622do_rm
dormers104313912dormers
dormy115817462dormy
dorp76028052do_rp
dorpers104113162dorpers
dorsa64617282dorsa
dorsers83516292dorsers
dorty96220812dorty
dory85836232do_ry
dos48062312do__s
dosers75723632dosers
doses65938502doses
doss56235042do_ss
doters74423912doters
dotes65836692dotes
dots55647662do_ts
doums85417642doums
dour56330432dour_
doura66518662doura
douras75016722douras
doves94728152doves
dowers104523292dowers
downs94918572downs
dowry126312482dowry
dows85941052do_ws
dozers164815422dozers
dozes155226302dozes
drops85719502drops
dross65418092dross
drys86314802d_rys
duras65727722duras
dures65635922dures
durns64819862durns
duros65422692duros
durr55624352durr_
durra65315792durra
durras74713372durras
dyers96617132dyers
errs45622532_errs
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
forts86034452forts
fours85521492fours
goers65520252goers
gores65740372gores
gorms85619592gorms
gorps85316992gorps
hoars85925542hoars
hoers85724922hoers
horas86333092horas
horns86125332horns
hours85422382hours
koras95927112koras
kors85933012ko_rs
lords64923502lords
lores55045402lores
loris55329152loris
lorry86315672lorry
lours55125292lours
moors74923142moors
moras76438762moras
mores76249642mores
morns75527442morns
morris83814722morris
morro73216952morro
morros83714672morros
mors65950062mo_rs
morts75533562morts
murrs75521292murrs
noirs55615462noirs
noris54928272noris
norms76019302norms
oars46846032_oars
odors64514272odors
odours7418232odours
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
orra46120722_orra
orris54516552_orris
ors35750112_o_rs
orts46538332_orts
ours47237562_ours
parrs75928672parrs
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
pours74623182pours
purrs75320432purrs
roars55622232roars
soars54732512soars
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028412sorns
sorry84618252sorry
sorts54536662sorts
sorus54527582sorus
sours55230502sours
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torr45630902torr_
tors46157382to_rs
torts56138122torts
torus54329762torus
tours55325862tours
words95425072words
works125621902works
worms105320752worms
worry116114332worry
worts88631182worts
yirrs8469192yirrs
yores85031322yores
yours85217872yours
zoris145320012zoris

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.0931921408.6
2DLD Change Limit538002051.62633087.3
3Display Results2052050.0633254.0
 (SQL Overall)1786912051.782100275.5
 
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.