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

63 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
dandyish164472(None) 
dandyism1543941dandyism
dandyishly2151682dandyishly
dandyisms1643222dandyisms
danish101513792dan__ish
dowdyish1952832dowdyish
ladyish14287822la_dyish
nannyish1443302nannyish
sandfish1556682sandfish
zanyish2235902zan_yish
anguish11117633_anguish
babyish1736513ba_byish
baldish1339503bald_ish
bandying15218073bandying
banish111416043ban__ish
blandish1497003bland_ish
brandish1469023brand_ish
caddish143810123ca_ddish
candying15188993candying
dadaism1136443da_daism
dadaist9310103da_daist
dampish1567663da_mpish
danders93921183danders_
dandier93714573dand_ier
dandies94121443dand_ies
dandiest103415033dandiest
dandify15245673dand_ify
dandily12279633dand_ily
dandles94218533dandles_
dandling112511733dandling
dandriff1694173dandriff
dandy104416703dandy___
darkish1537943da_rkish
donnish11187633don_nish
dryish1336323d__ryish
dudish1148313d_ud_ish
duncish1335793dun_cish
faddish15359003fa_ddish
handlist12311333handlist
jadish17319903ja_d_ish
kaddish16317973ka_ddish
laddish12299723la_ddish
ladyfish1843803la_dyfish
languish12136253languish
lazyish22265853la_zyish
maddish14289483ma_ddish
maidish13239553maid_ish
mannish121710693man_nish
ninnyish1442843ninnyish
pandying15217663pandying
panfish15229973pan_fish
radish103516913ra_d_ish
rankish14510383ran_kish
rowdyish1852663rowdyish
sandhis1139993sandhis_
sandwich1743653sandwich
standish1238543stand_ish
tannish101610573tan_nish
toadyish1544153toadyish
tundish1137283tund_ish
vandalish1645993vandalish
vanish121513203van__ish
vanquish2343543vanquish

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 Filter1786911461620.1701051123.5
2DLD Change Limit146162638.42317352.7
3Display Results63630.0163937.5
 (SQL Overall)178691638.60920756.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.