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

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

77 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
squawfishes295204(None) 
sawfishes1845742s__awfishes
squawbushes2851082squawbushes
squawfish2742262squawfish__
crawfishes2143593_crawfishes
sheatfishes2052483sheatfishes
spearfishes1953163spearfishes
squashes20207803squa___shes
squishes20198393squ___ishes
starfishes1646153s_tarfishes
studfishes17103793stu_dfishes
suckfishes2243433s_uckfishes
sunfishes1547033s_u_nfishes
surffishes1984073s_urffishes
batfishes1746584__batfishes
blowfishes2143464_blowfishes
bluefishes1844314blu_efishes
boarfishes1844974_boarfishes
catfishes1746304__catfishes
coalfishes1844694_coalfishes
cowfishes2045724__cowfishes
crawfished2242254_crawfished
crayfishes2143404_crayfishes
dealfishes1744194_dealfishes
drumfishes1942754dru_mfishes
equalises1847254equa_lis_es
flatfishes1943994_flatfishes
garfishes16167084__garfishes
goatfishes1743934_goatfishes
grayfishes2043634_grayfishes
hagfishes1945154__hagfishes
headfishes2044414_headfishes
jewfishes2543384__jewfishes
lumpfishes2042874_lumpfishes
lungfishes1743414_lungfishes
mudfishes1844194_mu_dfishes
numbfishes2042784_numbfishes
oarfishes15156954__oarfishes
outfishes15118024_ou_tfishes
outwishes15126564_outw_ishes
panfishes1737594__panfishes
pupfishes1944314_pu_pfishes
quaiches2235344_qua__iches
quamashes2343974_qua_mashes
quashes192110974_qua___shes
ratfishes1546104__ratfishes
sablefishes1952894sablefishes
sailfishes1644644s_ailfishes
sandfishes1745544s_andfishes
sawfish1637684s__awfish__
shellfishes2052584shellfishes
snakefishes2152414snakefishes
spadefishes2052694spadefishes
spearfished2052104spearfished
squallish2143404squallish__
squarish2047324squa_rish__
squarishly2542704squa_rishly
squarishness2452564squa_rishness
squashed21215984squa___shed
squasher20185784squa___sher
squashers21184984squa___shers
squatnesses2045214squatnesses
squawbush2651314squawbush__
squished21186394squ___ished
squooshes2142544squ__ooshes
squushes20194674squ___ushes
stablishes1545374s_tablishes
standishes1445714s_tandishes
stockfishes2352884stockfishes
stonefishes1753714stonefishes
swellfishes2052144swellfishes
swishes133411374s___w_ishes
swordfishes2152164swordfishes
toadfishes1743794_toadfishes
trunkfishes2151774trunkfishes
unwishes14147484__unw_ishes
weakfishes2343354_weakfishes

Search took 9 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 Filter1786911488190.423422437.4
2DLD Change Limit148819778.11018350.1
3Display Results77770.0302566.7
 (SQL Overall)178691778.56320867.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.