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

34 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
pharaonic164576(None) 
harmonic1589432_harmonic
paranoic1249832p_aranoic
parsonic1239702p_arsonic
baryonic1546203_baryonic
carbonic1439993_carbonic
chorionic1646493chorionic
chronic14311423ch_r_onic
enharmonic1752653enharmonic
hadronic1447953_hadronic
harmonica16105753_harmonica
harmonics16107403_harmonics
hormonic1568153_hormonic
inharmonic1752743inharmonic
parabolic1546283p_arabolic
paranoia10410563p_aranoia
paranoiac1346263p_aranoiac
paranoics1347653p_aranoics
paranoid11311143p_aranoid
parodic122311723p_ar_odic
parotic112518043p_ar_otic
pharaoh1545033pharao__h
pharaohs1644493pharao_hs
pharisaic1644633pharisaic
phonic133315213ph___onic
phoronid1449073phor_onid
photonic15312103ph_otonic
phratric1545953ph_ratric
phrenic1438773ph_r_enic
phytonic1848203ph_ytonic
platonic1238773pla_tonic
puranic11410483p_ura_nic
sardonic1147453_sardonic
shamanic1546573shama_nic

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 Filter1786911486410.423422437.4
2DLD Change Limit148641347.73319221.6
3Display Results34340.0162125.0
 (SQL Overall)178691348.17221866.3
 
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.