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

108 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
wispish157564(None) 
waspish1586921waspish
wimpish1765691wimpish
aspish114810332_aspish
hippish1736182hippish
impish13499192_impish
raspish1298102raspish
wampish1777292wampish
widish13419362wi_dish
wildish1446852wildish
winish124212262wi_nish
wispier12249402wispier
wispiest1339512wispiest
wispily1535652wispily
wisping133711942wisping
wisps105214182wisp_s_
apish105116633__apish
aspis74618143_aspis_
biggish14247503biggish
blimpish1743723blimpish
cuspis105010703cuspis_
dampish1567663dampish
despise1038683despise
dismiss1038153dismiss
dispose10312763dispose
distich13312173distich
dumpish15116113dumpish
duskish1535183duskish
finfish16268193finfish
finish124613413fi_nish
foppish1735103foppish
girlish1137193girlish
hashish1238353hashish
hickish1936473hickish
hispid1238173hispi_d
impis96213853_impis_
jiggish19225943jiggish
kiddish16276583kiddish
lisping103412753lisping
lisps76913913lisp_s_
lumpish14127383lumpish
minish115216303mi_nish
minxish1936213minxish
mispoise1248263mispoise
missis84417503missis_
mopish134311593_mopish
niseis63512023niseis_
pigfish16217173pigfish
piggish14227703piggish
pinfish15319303pinfish
pinkish16279113pinkish
pish96127913___pish
pixyish2253653pixyish
popish133812113_popish
quippish2442633quippish
rishis9312453rishis_
rompish1436693rompish
sickish1638423sickish
sissyish1442833sissyish
swampish1844173swampish
swinish1347203swi_nish
swish115114823__swish
tigrish1137573tigrish
tipis76019923ti_pis_
uppish1336633_uppish
vampish1766283vampish
waggish15207073waggish
waifish1637703waifish
warmish1538373warmish
waspier12259053waspier
waspiest1338823waspiest
waspily1535513waspily
waspishly2042613waspishly
wasps106714693wasp_s_
weakish17217173weakish
wearish132310153wearish
wennish1336243wennish
wettish1335963wettish
wheyish1944063wheyish
whish144512923w__hish
whitish1635973whitish
whorish1636603whorish
wimpier14248053wimpier
wimpiest1538763wimpiest
wimping153911013wimping
wimps125213803wimp_s_
wipes104827083wi_pes_
wiping123916713wi_ping
wiseass1035823wiseass
wises85633193wis_es_
wisest95016443wis_est
wish107228733w___ish
wishes124920953wishes_
wishing144114893wishing
wising103318223wis_ing
wisp97124073wisp___
wisped123411893wisp_ed
wispiness1435633wispiness
wisplike1734713wisplike
wispy137210973wisp__y
wiss75630543wis__s_
wisses94619603wisses_
wissing113212943wissing
wisting113519743wisting
wists86728523wis_ts_
woggish15276673woggish
wolfish1636933wolfish
wormish1537163wormish

Search took 7 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.656272394.8
2DLD Change Limit1340271086.14021828.5
3Display Results1081080.0303600.0
 (SQL Overall)1786911086.82626178.0
 
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.