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

107 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
outdoor83671(None) 
outdoer849271outdoer
outdoors936431outdoors
outcook1337202outcook
outdo6312702outd_o_
outdoers937512outdoers
outdoes8313122outdoes
outdone8311642outdone
outdoorsy1341782outdoorsy
outdrop1036192outdrop
outfool1037332outfool
outfoot10411492outfoot
outlook1138022outlook
outpour937422outpour
outroar739512outroar
outroot7516562outroot
outsoar739492outsoar
author939763aut_hor
boudoir1043853bou_doir
cutdown1344083cutdown
door56928513___door
indoor738403_indoor
nextdoor1651053nextdoor
nutwood1144953nutwood
odor55718093o__d_or
odour64710493o__dour
outbloom1244003outbloom
outboard1138323outboard
outbox1537463out_box
outcome11310573outcome
outcooks1436723outcooks
outcrop1146773outcrop
outcrow1246343outcrow
outdare83113403outdare
outdate83016423outdate
outdid81210923outd_id
outdodge1143773outdodge
outdoing1039423outdoing
outdrag937003outdrag
outdraw1136903outdraw
outdrew1137143outdrew
outdrops1136543outdrops
outdrove1236473outdrove
outduel837303outduel
outer55633303out__er
outflow1355353outflow
outfools1136533outfools
outfoots1136883outfoots
outfox1636143out_fox
outglow1154863outglow
outgo6312093out_go_
outgoes8312643outgoes
outgone8311463outgone
outgrow1136323outgrow
outhear10910603outhear
outhomer1348133outhomer
outhowl1337203outhowl
outhumor1342743outhumor
outlier72216143outlier
outlooks1236793outlooks
outlove102410243outlove
outmode10199663outmode
outmost9511213outmost
outmove12238713outmove
outplod10106343outplod
outplot9109483outplot
outpoll946793outpoll
outport9714123outport
outpost9612443outpost
outpours1036683outpours
outpower1336673outpower
outroars838923outroars
outrock1339303outrock
outrode82313423outrode
outroll749303outroll
outroots839873outroots
outrow9311183out_row
outrows10311403outrows
outsavor1194253outsavor
outscoop1243993outscoop
outscore10169203outscore
outscorn10166143outscorn
outshoot1149163outshoot
outshot10312103outshot
outsnore8187683outsnore
outsoars838853outsoars
outsold8109073outsold
outsole71013433outsole
outstood945933outstood
outswore11168673outswore
outsworn11166663outsworn
outtold8107603outtold
outtower1136193outtower
outtrot7312613outtrot
outvote1038803outvote
outwar91011513out_war
outwear1097713outwear
outwore101912693outwore
outwork141710353outwork
outworn101610753outworn
pandoor10358583pandoor
putdown1343883putdown
sudor6312623su_d_or
tandoor8278563tandoor
tutor5712493tut__or
undoer73113043_undoer
unmoor836313_unmoor

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.423422437.4
2DLD Change Limit1340271076.56320421.6
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.03225411.1
 
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.