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

91 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
phoneme144620(None) 
phonemes1546191phonemes
axoneme1644782axoneme
phoebe1335002pho_ebe
phonate12411812phonate
phone105621932phon__e
phoned124014552phone_d
phonemic1747172phonemic
phones114121212phone_s
phoney143612982phone_y
phoneyed1743842phoneyed
phoneys15437142phoneys
toneme8312102_toneme
axonemes1744333axonemes
choremen1597603choremen
donee66931013_done_e
heme95034413_h__eme
home98042443_ho__me
hondle103914523_hondle
hone77549323_hon__e
honed95332263_hone_d
honer85332093_hone_r
honers94324973_honers
hones88144493_hone_s
honest94822423_honest
honey115629913_hone_y
honeyed1437773_honeyed
honeys124016083_honeys
honkie133011673_honkie
mooneye12116933mooneye
nonheme1247133_nonheme
pawnee113115403pawne_e
penname11328553penname
peonage1048723peonage
peones83821043peone_s
phenate12412203phenate
phenom1339473phenom_
phenoms1437813phenoms
phloem1335713phloem_
phloems1433523phloems
phocine1438833phocine
phoebes1435813pho_ebes
phoenix1944363phoenix
phon95925383phon___
phonal11310383phon_al
phonated1447893phonated
phonates13410643phonates
phonemics1844933phonemics
phonetic15310323phonetic
phonic133315213phon_ic
phonics143110723phonics
phonied133710563phonied
phonier122710633phonier
phonies123717513phonies
phoniest132811543phoniest
phonily1537103phonily
phoning13312053phoning
phono104917023phon__o
phonon114012033phon_on
phonons123310253phonons
phonos114114793phon_os
phons105221143phon__s
phony136715443phon__y
phooey14379233phooe_y
phorate12413363phorate
phoresy1534653phoresy
phosgene1444103phosgene
pinene82915643p_inene
pioneer936893pioneer
poem86225773p_o_em_
poems95715553p_o_ems
pome85636693p_o__me
pommee122813283p_ommee
ponce95222513p_on_ce
pone65747533p_on__e
ponent82821593p_onent
pones74547043p_one_s
pongee94920193p_ongee
prename11412643prename
proem94818273pro_em_
proems104711163pro_ems
pronate9418873pronate
prone75332623pron__e
pronely12310253pronely
propene112716043propene
protege1059153protege
proteome12228423proteome
rheme106214053rh__eme
shone83725983shon__e
theme105921733th__eme
tonemes9311683_tonemes

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.406440125.6
2DLD Change Limit134027916.37621020.5
3Display Results91910.0303033.3
 (SQL Overall)178691916.81226231.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.