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

106 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
outlooks123679(None) 
outcooks1436721outcooks
outlook1138021outlook_
outblooms1342972outblooms
outcook1337202outcook_
outdoors936432outdoors
outfools1136532outfools
outfoots1136882outfoots
outloves11249672outloves
outrocks1437902outrocks
outroots839872outroots
outworks15148972outworks
boathooks1844173boathooks
bullocks1636293bullocks
buttocks1645233buttocks
cutworks17166003cutworks
doubloons1242823doubloons
fetlocks1744713fetlocks
futhorks1844603futhorks
futtocks1743833futtocks
gunlocks1544683gunlocks
hulloos104010073hulloo_s
looks95124863___looks
mullocks1645033mullocks
nutwoods1244263nutwoods
oarlocks1445103oarlocks
olicooks1443753olicooks
outasks1138173out_asks
outbacks1638983outbacks
outbarks1437833outbarks
outbloom1244003outbloo_m
outboxes1737823outboxes
outbulks1444763outbulks
outcomes1239763outcomes
outcooked1645313outcooked
outcrops1246853outcrops
outcross1036823outcross
outcrows1346653outcrows
outdoers937513outdoers
outdoes8313123out_does
outdoor836713outdoo_r
outdoorsy1341783outdoorsy
outdrops1136543outdrops
outflanks1643233outflanks
outfloats1243573outfloats
outflows1445463outflows
outfool1037333outfoo_l
outfoot10411493outfoo_t
outfoxes1836743outfoxes
outglows1244933outglows
outgoes8312643out_goes
outgross936423outgross
outgrows1236283outgrows
outhowls1445723outhowls
outkicks1344603outkicks
outlands988563outlands
outlasts8108713outlasts
outlaws10249603outl_aws
outlays102610903outl_ays
outleads9278763outleads
outleaps10237073outleaps
outlets73616363outl_ets
outliers82610673outliers
outlies72421993outl_ies
outlines82418093outlines
outlives112511763outlives
outlove102410243outl_ove
outloved12248583outloved
outmodes11208963outmodes
outmoves13228173outmoves
outplods11105613outplods
outplots1086363outplots
outpolls1046213outpolls
outports1048273outports
outposts1037253outposts
outpours1036683outpours
outranks12298823outranks
outroars838923outroars
outrock1339303outrock_
outrolls847823outrolls
outroot7516563outroo_t
outrows10311403out_rows
outscoops1343403outscoops
outshoots1245393outshoots
outslicks1543823outslicks
outsmoke1445753outsmoke
outsmokes1545313outsmokes
outsoars838853outsoars
outsoles8813113outsoles
outspoke1446493outspoke
outsulks1244993outsulks
outtalks1236503outtalks
outtasks1235633outtasks
outtrots838373outtrots
outvotes1137903outvotes
outwalks1535993outwalks
outwork141710353outwork_
overlooks1685483overlooks
oxbloods1842753oxbloods
pothooks1746053pothooks
putlogs1065083putl_ogs
relooks114010723_relooks
stooks105115373_st_ooks
unhooks1436413_unhooks
unlocks1337063_unlocks
witloofs1442503witloofs

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621067.31019994.8
3Display Results1061060.0502120.0
 (SQL Overall)1786911067.76623009.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.