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

114 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
outled7402034(None) 
butled94818601butled
outed65429061out_ed
outlead83311101outlead
outlet63728681outlet
autoed7712822autoed
bottled104611232bottled
bugled104918132bugled
bulled94626492bulled
burled94825382burled
bustled104011522bustled
butle75023102butle_
butler84220032butler
butles84423912butles
butted94722062butted
coupled124312672coupled
culled94022472culled
curled95021652curled
cutler84718032cutler
cutlet84924362cutlet
cuttled10319932cuttled
doubled11289952doubled
dueled84813662dueled
dulled84719422dulled
footled113610762footled
fouled104315972fou_led
fueled104913602fueled
fugled114813692fugled
fulled103820652fulled
furled104717052furled
futzed19418982futzed
guiled84315382guiled
gulled84521372gulled
gutted84716362gutted
guttled9378992guttled
hulled103920012hulled
hurled104617452hurled
hurtled11339592hurtled
hustled113210132hustled
hutted104616332hutted
jostled15267082jostled
justled15338092justled
jutted144315022jutted
louted74920692lout_ed
lulled74516442lulled
luted64826142lut_ed
mottled10409972mottled
moulted103310312moulted
mouthed133811042mouthed
muled85824432mu_led
mulled94721552mulled
muted85023382mut_ed
nulled74318272nulled
nurled74016232nurled
nutlet64220562nutlet
nutted74316972nutted
ogled75915962o_gled
oiled64429472o_iled
opted84914272opt_ed
ostler63312192ostler
ouched124316932ouched
ousted73720582ousted
outadd837802outadd
outbeg938732outbeg
outbid91411862outbid
outbred10311262outbred
outdid81210922outdid
outer55633302out_er
outflew1336422outflew
outlaid81110652outlaid
outland81212342outland
outlaw9279642outlaw
outlawed1238042outlawed
outlay92711792outlay
outleads9278762outleads
outleap9298292outleap
outlets73616362outlets
outlie62419532outlie
outlier72216142outlier
outlies72421992outlies
outlined92512952outlined
outlived12269582outlived
outloved12248582outloved
outplod10106342outplod
outre53922202outre_
outread82811092outread
outsee63121802outsee
outset64027452outset
outsped101110322outsped
outvied11239692outvied
outwiled1237602outwiled
pouted94021392pout_ed
puled84926522pu_led
pulled94322192pulled
purled94520752purled
putted94220252putted
putzed18409112putzed
rootled83410532rootled
routed75624332rout_ed
ruled65822522ru_led
rustled83311322rustled
rutted74518402rutted
souled75419822sou_led
southed114313992southed
sutler63718392sutler
titled73815002titled
tootled83511042tootled
tousled84710362tousled
touted74419742tout_ed
touzled17367152touzled
turtled8309682turtled
tutted75117442tutted
tutued7349412tutued
unled64021072_unled

Search took 5 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 Filter178691825510.360496363.9
2DLD Change Limit825511143.72022191.1
3Display Results1141140.0303800.0
 (SQL Overall)1786911144.11043477.1
 
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.