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

120 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
outfishes1511802(None) 
outfished16116601outfished
outwishes15126561outwishes
batfishes1746582batfishes
catfishes1746302catfishes
goatfishes1743932goatfishes
mudfishes1844192mudfishes
oarfishes15156952oarfishes
outfights1643782outfights
outfires1139862outfi_res
outfish132210572outfish__
outgushes1344852outgushes
outkisses1344302outkisses
outpushes1445252outpushes
outrushes1246652outrushes
outwashes15116182outwashes
outwished1655682outwished
pupfishes1944312pupfishes
ratfishes1546102ratfishes
sunfishes1547032sunfishes
baitfishes1844053baitfishes
bluefishes1844313bluefishes
boarfishes1844973boarfishes
bonefishes1844913bonefishes
boxfishes2444153boxfishes
burnishes1436643burnishes
coalfishes1844693coalfishes
codfishes1845643codfishes
cowfishes2045723cowfishes
cuishes122810823cu__ishes
cutises94414913cut_is_es
dogfishes1745083dogfishes
drumfishes1942753drumfishes
fetishes1437153fet_ishes
finfishes1846043finfishes
fishes125221343___fishes
flatfishes1943993flatfishes
foolfishes1943763foolfishes
foxfishes2544053foxfishes
frostfishes2052273frostfishes
furbishes1745243furbishes
furnishes1536233furnishes
garfishes16167083garfishes
goldfishes1863563goldfishes
hagfishes1945153hagfishes
hogfishes1944683hogfishes
jewfishes2543383jewfishes
lumpfishes2042873lumpfishes
lungfishes1743413lungfishes
lutfisks1542333lutfis_ks
monkfishes2243743monkfishes
moonfishes1844193moonfishes
nourishes12116733nou_rishes
numbfishes2042783numbfishes
ostriches1446633ostriches
outbitches1742653outbitches
outblushes1543463outblushes
outcastes11118903outcastes
outcities1149513outcities
outfables1485563outfables
outfaces132311393outf_aces
outfasted13147173outfasted
outfasts11117233outfas_ts
outfences1456463outfences
outfields1373123outfields
outfight1546103outfigh_t
outfigures1442303outfigures
outfinds1235643outfi_nds
outfire1049713outfi_re_
outfired1238083outfi_red
outfishing1765993outfishing
outfits102210833outfi__ts
outfitted1345193outfitted
outfitter1243913outfitter
outfitters1342753outfitters
outflies11310153outf_lies
outfoxes1836743outf_oxes
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
outwastes12127693outwastes
outwiles1139233outwi_les
outwish13289853outwish__
overfishes1947013overfishes
panfishes1737593panfishes
pigfishes1845003pigfishes
pinfishes1746243pinfishes
publishes1645933publishes
punishes1338113pu_nishes
redfishes1645793redfishes
rockfishes2263513rockfishes
rosefishes1644113rosefishes
rubbishes1644303rubbishes
sawfishes1845743sawfishes
studfishes17103793studfishes
suckfishes2243433suckfishes
surffishes1984073surffishes
toadfishes1743793toadfishes
tundishes1344543tundishes
unfished15218293_unfished
unwishes14147483_unwishes
wolffishes2242983wolffishes

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.420425454.8
2DLD Change Limit1486411207.25020502.2
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.71623158.5
 
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.