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

102 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
outdance1123873(None) 
outdanced13226571outdanced
outdances12198501outdances
outrance102212781outrance
guidance1244982guidance
outdare83113402outda_re
outdate83016422outda_te
outdone8311642outdon_e
outface123011972outfa_ce
outfence1356972outfence
outpace112613022outpa_ce
outrace92418552outra_ce
outrances112912112outrances
outrange92410222outrange
abidance1346323abidance
abundance1443643abundance
acutance1246303acut_ance
buoyance1543713buoyance
butane8313653but_an_e
dance85223133___dance
durance1059113du_rance
entrance10311333entrance
guidances1344773guidances
lurdane835983lurdan_e
mundane1038073mundan_e
nondance1148243nondance
nuance859043nu__ance
nuisance1045713nuisance
octane81411633oct_an_e
ordnance1144833ordnance
ounce77019933ou___nce
outact8317203out_a_ct
outage72017533out_a_ge
outate62923403out_a_te
outback15310653outba_ck
outbake13310773outba_ke
outbalance1452943outbalance
outcaste10119613outcaste
outcatch1544293outcatch
outdancing1445223outdancing
outdared102711513outdared
outdares92712463outdares
outdated1012513193outdated
outdates93114743outdates
outdazzle1841803outdazzle
outdistance1452013outdistance
outdodge1143773outdodge
outdrank1345433outdran_k
outdrive1236893outdrive
outdrove1236473outdrove
outfable1378813outfable
outfaced14219463outfa_ced
outfaces132311393outfa_ces
outfenced1555093outfenced
outfences1456463outfences
outgave11259563outga_ve
outgaze17239223outga_ze
outgone8311463outgon_e
outhandle1374203outhandle
outland81212343outlan_d
outlander1045733outlander
outlands988563outlands
outline72321333outlin_e
outman83115033outman__
outmanned1245483outmanned
outmans92413283outman_s
outmarch1544793outmarch
outmatch1544173outmatch
outpaced13269793outpa_ced
outpaces122411943outpa_ces
outplace1257913outplace
outprice1238273outprice
outpunch1543303outpunch
outraced112414203outra_ced
outraces102217863outra_ces
outrage82616893outra_ge
outraise8311933outraise
outran63218893outran__
outrang83813953outran_g
outranged11239043outranged
outranges102510013outranges
outrank112611973outran_k
outranked14247863outranked
outranks12298823outranks
outrate72323183outra_te
outrave102614413outra_ve
outsang83411273outsan_g
outtake11310793outta_ke
outvalue1144233outvalue
outvoice1344793outvoice
outwaste11147943outwaste
outwatch1643903outwatch
pittance1246113pittance
portance12310123port_ance
quittance2043543quittance
riddance1243973riddance
soutane7312063sout_an_e
stance84316913_st_ance
tendance1147523tendance
trance84718763__trance
usance858013_u_sance
voidance1444723voidance

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.436409841.7
2DLD Change Limit1461621027.31319986.6
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.79522923.8
 
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.