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

142 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
outspan93874(None) 
outspans1038221outspans
dustpan1043242dustpan
outman83115032out_man
outplan9249442outplan
outran63218892out_ran
outsang83411272outs_ang
outsat62920282outs_at
outsaw92610282outs_aw
outsay92611872outs_ay
outseen72712332outseen
outsin63617562outs_in
outsoar739492outsoar
outspeak1454582outspeak
outsped101110322outsped
outspend11126202outspend
outspent101310212outspent
outsprang1243902outsprang
outstand938042outstand
outstay1047682outstay
outswam1246612outswam
automan9310883automan
autopen947123autopen
batsman1157993batsman
boatsman1245703boatsman
busman10310253bu_sman
catspaw1443353catspaw
cuspal1037883cu_spal
dustman1044683dustman
dustpans1143233dustpans
fustian1036903fustian
huntsman1343863huntsman
hutzpa2052813hutzpa_
hutzpah2441803hutzpah
hutzpas2142693hutzpas
inspan837513_inspan
oarsman937733oarsman
octan71313483oct__an
ortolan747083ortolan
ottoman946283ottoman
outbeam1137973outbeam
outbrag1036993outbrag
outburn936903outburn
outdrag937003outdrag
outdrank1345433outdrank
outdraw1136903outdraw
outdrawn1245013outdrawn
outearn7310683outearn
outeat62824533out_eat
outfawn1335983outfawn
outflank1544593outflank
outgain81010743outgain
outgas7313203out_gas
outgnaw11124353outgnaw
outgnawn12122933outgnawn
outgrin8810553outgrin
outgun7349643out_gun
outhear10910603outhear
outlain71212613outlain
outland81212343out_land
outlaw9279643out_law
outlay92711793out_lay
outlead83311103outlead
outleap9298293outleap
outlearn836433outlearn
outmans92413283out_mans
outpace112613023out_pace
outpaint10311773out_paint
outpass939713out_pass
outplans10259533outplans
outplay12267723outplay
outpray12268083outpray
output8712853out_put
outrang83813953out_rang
outrank112611973out_rank
outread82811093outread
outroar739513outroar
outrun63213303out_run
outs45746963outs___
outsaid81210923outsaid
outsail71411413outsail
outsays102710403outsays
outscorn10166143outscorn
outsee63121803outs_ee
outsees72616433outsees
outsell7109263outsell
outsert72819513outsert
outset64027453outs_et
outsets73514923outsets
outshame1346743outshame
outshine11310723outshine
outshone1149343outshone
outshot10312103outshot
outside82414193outside
outsing83320463outsing
outsins73417863outsins
outsit63620893outs_it
outsits73215253outsits
outsize162411753outsize
outskate12168013outskate
outsmart10168923outsmart
outsoars838853outsoars
outsold8109073outsold
outsole71013433outsole
outspanned1343453outspanned
outspeaks1554013outspeaks
outspeed11117933outspeed
outspell10125453outspell
outspelt10148403outspelt
outspends1294123outspends
outspoke1446493outspoke
outspoken1544373outspoken
outspread1243503outspread
outspring1238903outspring
outsprint1148203outsprint
outsprung1243153outsprung
outstands1045543outstands
outstare81410693outstare
outstart81611283outstart
outstate81411993outstate
outstays1156623outstays
outstunt847223outstunt
outsulk1156323outsulk
outsung8348153outsung
outsware11168843outsware
outswear1144793outswear
outswim1244843outswim
outswing1259283outswing
outsworn11166663outsworn
outswum1244563outswum
outswung1253793outswung
outthank1544353outthank
outturn737123outturn
outwar91011513out_war
outwear1097713outwear
outworn101610753outworn
routeman10135493routeman
southpaw1641973southpaw
span65234663___span
ulpan7310123_u_lpan
unspun865793_unspun
utopian9126273_utopian

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 Limit1340271426.61020276.4
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.07625253.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.