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 “outroll” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

160 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
outroll74930(None) 
outpoll946791outpoll
outrolls847821outrolls
outcall9310122outcall
outfall1039682outfall
outfool1037332outfool
outhowl1337202outhowl
outkill1136552outkill
outpolls1046212outpolls
outpull956442outpull
outroar739512outroar
outrock1339302outrock
outrode82313422outrode
outrolled1037432outrolled
outroot7516562outroot
outrow9311182outro_w
outrows10311402outrows
outsell7109262outsell
outsold8109072outsold
outsole71013432outsole
outtell797882outtell
outtold8107602outtold
outwill1037322outwill
outyell1095842outyell
stroll6311602_stroll
troll54416532__troll
unroll61210072_unroll
antiroll847763antiroll
atoll57913923_at_oll
bedroll1055553bedroll
control9310693contro_l
controls10311393controls
droll65415403__droll
drumroll1141773drumroll
enroll61110073_enroll
extoll1334863ext_oll
logroll844263logroll
nutgall844443nutgall
octroi837363octro_i
octrois938343octrois
ostiole739013ostiole
outbawl1237473outbawl
outbox1537463outbo_x
outbrawl1344823outbrawl
outbulk1336003outbulk
outbully1345103outbully
outcalls1038743outcalls
outcome11310573outcome
outcook1337203outcook
outcrawl1344583outcrawl
outcrop1146773outcro_p
outcrops1246853outcrops
outcross1036823outcross
outcrow1246343outcro_w
outcrowd1444933outcrowd
outcrows1346653outcrows
outdo6312703outdo__
outdoer849273outdoer
outdoes8313123outdoes
outdone8311643outdone
outdoor836713outdoor
outdrop1036193outdro_p
outdrops1136543outdrops
outdrove1236473outdrove
outduel837303outduel
outfalls1138143outfalls
outfeel1037543outfeel
outfelt10310603outfelt
outflow1355353outflow
outfly1238273out_fly
outfools1136533outfools
outfoot10411493outfoot
outfox1636143outfo_x
outfrown1444863outfrown
outglow1154863outglow
outgo6312093outgo__
outgoes8312643outgoes
outgone8311463outgone
outgross936423outgross
outgroup1144393outgroup
outgrow1136323outgro_w
outgrown1245093outgrown
outgrows1236283outgrows
outhaul1039063outhaul
outhowls1445723outhowls
outkills1245143outkills
outlook1138023outlook
outlove102410243outlove
outmode10199663outmode
outmost9511213outmost
outmove12238713outmove
outplod10106343outplod
outplot9109483outplot
outpolled1246173outpolled
outport9714123outport
outpost9612443outpost
outpour937423outpour
outpulls1065443outpulls
outrace92418553outrace
outrage82616893outrage
outran63218893outr_an
outrang83813953outrang
outrank112611973outrank
outrate72323183outrate
outrave102614413outrave
outre53922203outr__e
outread82811093outread
outride82615683outride
outrig72812853outr_ig
outrigs82811263outrigs
outring84021023outring
outrival1145323outrival
outroars838923outroars
outrocks1437903outrocks
outrolling1137533outrolling
outroots839873outroots
outrowed1239443outrowed
outrun63213303outr_un
outrung8349573outrung
outruns72911543outruns
outrush1037043outrush
outsail71411413outsail
outscold11115253outscold
outsells888653outsells
outsmell1075523outsmell
outsoar739493outsoar
outsoles8813113outsoles
outspell10125453outspell
outsulk1156323outsulk
outtalk1138233outtalk
outtells896853outtells
outtrot7312613outtro_t
outtrots838373outtrots
outvote1038803outvote
outwalk1437623outwalk
outwile10310263outwile
outwills1135653outwills
outwore101912693outwore
outwork141710353outwork
outworn101610753outworn
outwrote1137723outwrote
outyells11105303outyells
outyelp1294323outyelp
overall10411083overall
patrol83213023patro_l
patrols93513513patrols
payroll1245613payroll
petrol82714063petro_l
petrols92913083petrols
quoll14379493qu__oll
reroll6412683_reroll
roll46331653___roll
scroll8310173_scroll
strolls739183_strolls
toll45535263__t_oll
trill55122933__trill
trolls64613943__trolls
trolly94012363__trolly
trull54012673__trull
unrolls797793_unrolls

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271606.97019229.1
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.43924020.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.