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

88 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
fishnet1341034(None) 
fishnets1445631fishnets
fished134316312fish_ed
fisher124917142fish_er
fishes125221342fish_es
fishier13359852fishier
fishiest14310452fishiest
basinet9318933basinet
dipnet91317473di_pnet
dished114318713dish_ed
dishes104622653dish_es
dishier113613403dishier
dishiest12313683dishiest
dishonest13410773dishonest
dissent84018683dissent
distent84120853distent
fashed136720253fash_ed
fashes124524023fash_es
fiche134616743fich_e_
fiches145219533fich_es
fidget114216483fi_dget
fight124027093figh__t
fighter143010773fighter
figment1379743figment
filet85540163fi__let
fillet95027083fi_llet
filmset1257513filmset
fine75147963fi__ne_
fined94930503fi__ned
finer85431563fi__ner
fines86644263fi__nes
finest94321733fi__nest
finned104114603fi_nned
fish106926283fish___
fishbolt1644663fishbolt
fishbone1644663fishbone_
fishbones1744263fishbones
fishers134714723fishers
fishery16397733fishery
fisheye1644773fisheye
fisheyes1744093fisheyes
fishgig1542103fishgig
fishily1637643fishily
fishiness1537343fishiness
fishing143913863fishing
fishings15307693fishings
fishless1436413fishless
fishline14237583fishline_
fishlines15246843fishlines
fishmeal1642663fishmeal
fishway1943813fishway
fishy146011663fish__y
fissate103010033fissate
fist76248433fis___t
fisted104218703fis_ted
fistnote1144323fistnote
fitchet153113563fitchet
fitment12710303fitment
flysheet1745113flysheet
freshet133416643fresh_et
frisket143811773fris_ket
gillnet839733gillnet
islet54527553_is_let
isohyet1345333_isohyet
kishke1254273kishke_
kishkes1334773kishkes
kismet123414623kis_met
linnet6419423li_nnet
lisente71210703lisente
mishit112618203mish_it
misknew1633883misknew
mismeet113215163mismeet
mismet103722373mis_met
missent94318713missent
misset85028153mis_set
pished124817063pish_ed
pisher114317753pish_er
pishes114722103pish_es
sheet84836963__sheet
shent85933503__shent
signet73621153si_gnet
tipsheet1345833tipsheet
tisane6311573tisane_
tisanes7311853tisanes
wisent93516343wisen_t
wished134417513wish_ed
wisher123617063wish_er
wishes124920953wish_es

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.436409841.7
2DLD Change Limit134027886.62320236.6
3Display Results88880.0332666.7
 (SQL Overall)178691887.09225196.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.