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 “outwishes” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
outwishes1512656(None) 
outfishes15118021outfishes
outwashes15116181outwashes
outwished1655681outwished
outfished16116602outfished
outgushes1344852outgushes
outkisses1344302outkisses
outpushes1445252outpushes
outrushes1246652outrushes
outwastes12127692outwastes
outwiles1139232outwi_les
outwish13289852outwish__
unwishes14147482_unwishes
batfishes1746583batfishes
burnishes1436643burnishes
catfishes1746303catfishes
cuishes122810823cu__ishes
cutises94414913cut_is_es
fetishes1437153fet_ishes
furbishes1745243furbishes
furnishes1536233furnishes
goatfishes1743943goatfishes
mouthwashes2262063mouthwashes
mudfishes1844193mudfishes
nourishes12116733nou_rishes
oarfishes15156953oarfishes
ostriches1446633ostriches
outbitches1742653outbitches
outblushes1543463outblushes
outcastes11118903outcastes
outcities1149513outcities
outfights1643783outfights
outfires1139863outfi_res
outfish132210573outfish__
outgasses1036663outgasses
outgives12218623outgi_ves
outgushed1444483outgushed
outjinxes2343113outjinxes
outkiss1137783outkis__s
outkissed1443843outkissed
outlies72421993outli__es
outlines82418093outli_nes
outlives112511763outli_ves
outpasses1146613outpasses
outpitches1743063outpitches
outpities1148623outpities
outpushed1544763outpushed
outraises9311023outrais_es
outrides92414993outri_des
outrushed1346293outrushed
outsees72616433out__sees
outsides92513233outsi_des
outsights1344183outsights
outsizes172311083outsi_zes
outvies102214243outvi__es
outwash13187613outwash__
outwaste11147943outwaste_
outwasted13137683outwasted
outwatches1843473outwatches
outweighed1842743outweighed
outweighs1642893outweigh_s
outwile10310263outwi_le_
outwiled1237603outwi_led
outwilled1345013outwilled
outwills1135653outwi_lls
outwinded1444663outwinded
outwinds1235363outwi_nds
outwishing1765793outwishing
outwith13279133outwith__
outwits103110863outwi__ts
outwitted1345133outwitted
outwrites1238233outwrites
publishes1645933publishes
punishes1338113pu_nishes
pupfishes1944313pupfishes
ratfishes1546103ratfishes
rubbishes1644303rubbishes
sunfishes1547033sunfishes
swishes133411373__swishes
tundishes1344543tundishes
unwished15237833_unwished
wishes124920953___wishes

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 Filter1786911486410.483369960.7
2DLD Change Limit148641826.84321721.6
3Display Results82820.0461782.6
 (SQL Overall)178691827.37224239.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.