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 “pyelitis” 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
pyelitis134658(None) 
myelitis1345111myelitis
pyelitic1547591pyelitic
pelites93821992p_elites
pelitic111814652p_elitic
pyelitises1544852pyelitises
thelitis1147512thelitis
adenitis947433adenitis
colitis92617353_colitis
cystitis1345713cystitis
elites66027123__elites
elitism939763__elitism
elitist7414913__elitist
eyelets1057523eyelet_s
eyelids1135943eyeli_ds
eyelifts1462753eyelifts
gelatis83313513_gelatis
hyalites14208833hyalites
ileitis738063ile_itis
myelines1337123myelines
myelinic1544243myelinic
myelins1237353myeli_ns
myelitides1642813myelitides
myositis1345633myositis
peelings11339523peelings
peewits12105873peewit_s
pelite84323003p_elit_e
pelotas9410723p_elotas
pelts76128813p_el_t_s
pelvis113610323p_el_vis
penlites10312273penlites
periti8319953p_eriti_
peritus9311803p_eritus
perlites10316353perlites
perlitic12310583perlitic
petites93820203p_etites
pewits112810683p_ewit_s
phlebitis1643313phlebitis
phrenitis1445623phrenitis
phyllites1745323phyllites
phyllitic1944423phyllitic
politic112918713p_olitic
politics122513813p_olitics
polities102722343p_olities
poplitic14510013poplitic
prelates10418573prelates
prelatic12311283prelatic
prelatism1347853prelatism
prelimit1259123prelimit
prelimits1366013prelimits
prelims1139823preli_ms
prelives13310383prelives
pyemias1436803pyemi_as
pyrites12812203py_rites
pyritic143311313py_ritic
syenites1138943syenites
syenitic1346743syenitic
typhlitis1753323typhlitis
uveitis1043683uve_itis
uvulitis1142733uvulitis
velites103417303_velites
yetis85418393_ye__tis
yperites13310153yperites

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162637.18620339.8
3Display Results63630.0331909.1
 (SQL Overall)178691637.37524229.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.