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

160 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
prentice12101235(None) 
prenticed14118061prenticed
prentices131111901prentices
apprentice1654322apprentice
entice81316862__entice
practice1438732practice
preprice1488872preprice
preslice1258622preslice
prestige11310732prestige
agentive1248043agentive
apprenticed1852743apprenticed
apprentices1753563apprentices
arenite71017713aren_ite
argentic1149023argentic_
argentine1047893argentine
argentite1047813argentite
brattice1245693brattice
centile94217183_centile
centime114513033_centime
creatine103417413creatine
creative132812803creative
cretic102816283cre_tic_
cretics112911653cre_tics
crevice1436153cre_vice
denticle1137773_denticle
dentine83320243_dentine
enticed101411193__enticed
enticer91510423__enticer
entices91616333__entices
entire61617703__entire
erectile1039513erectile
erective13311833erective
eventide1246853eventide
frantic12310373frantic_
frenetic1346293frenetic_
frenetics1444603frenetics
gentile83515293_gentile
gentrice1148813_gentrice
identic1038043identic_
irenic8311103iren_ic_
irenics937833iren_ics
lentic83515743_lentic_
lenticel1066123_lenticel
orectic1138823orectic_
orective1339353orective
pantie84326473p_anti_e
pantile93918483p_antile
parentage1245603parentage
parenting12611583parenting
paretic113016673pare_tic_
paretics122312443pare_tics
pectic122913873p_ectic_
pectize20259913p_ectize
penance11313443p_enance
pence94924453p_en__ce
penile82219603p_en_ile
penlite9313243p_enlite
pennine93712953p_ennine
pensile92713543p_ensile
pensive122610393p_ensive
pentacle1239383p_entacle
pentane9415743p_entane
pentene9313793p_entene
pentode1039893p_entode
pentose9311593p_entose
peptic122113153p_eptic_
peptics132610243p_eptics
peptide122910683p_eptide
peptize20279483p_eptize
percentile1447413percentile
petite84320653p_e_tite
pfennige1461823pfennige
phenetic1549203phenetic_
phenetics1646483phenetics
phreatic1548343phreatic_
phrenetic1645923phrenetic_
phrenic1438773phren_ic_
plenties10314693plenties
poetic10416843poe_tic_
poetics11312073poe_tics
poetise9314043poe_tise
poetize18310773poe_tize
pontine92419053p_ontine
poultice1246063poultice
practic13312253practic_
practiced1655113practiced
practicer1544593practicer
practices1557993practices
practise12310143practise
prance104318573pran__ce
precative16312573precative
precipe133012123pre_cipe
precipice1745953precipice
precise113518173pre_cise
predict12315323pre_dict
predive13511083pre_dive
preemie11310563preemi_e
preface14510923pre_face
prefile123413183pre_file
prefire124012813pre_fire
preguide1255423preguide
preinvite1485443preinvite
prejudice2143343prejudice
prelatic12311293prelatic_
prelife1279943pre_life
premie103617993pre_mi_e
premise113818553pre_mise
prename11412643pren_ame
prenotify1744283prenotify
prenotion1149173prenotion
prenticing1547883prenticing
preplace1488983preplace
preppie1058093preppi_e
prepriced1676643prepriced
preprices1569263preprices
prepuce1337833pre_puce
prerace11414123pre_race
presence122213513presence
preside10715613pre_side
presliced1435983presliced
preslices1338213preslices
prestiges12310593prestiges
prestore104217353prestore
prestrike1547493prestrike
pretape113511623pre_tape
pretence122312123pretence
prettied1159253prettied
prettier1069043prettier
pretties10615133pretties
prettify1644343prettify
prettily1337283prettily
pretype14387483pre_type
preunite1039573preunite
preventive1847543preventive
previse123713793pre_vise
prewire124311143pre_wire
price93725413pr___ice
prince104114763prin__ce
principe1445683principe
printing113216083printing
pristine10313503pristine
prostie91617743prosti_e
pyretic143210783pyre_tic_
rejoice16287453_rejoice
rente54733783_rent__e
rentier73618223_rentier
renting84026853_renting
reprice113212833_reprice
reptile93914083_reptile
restive10315933_restive
reticle94112623_re_ticle
retie55735303_re_ti_e
retile65929673_re_tile
retime85321803_re_time
retine66237333_re_tine
retire64927013_re_tire
revoice12319183_revoice
tentie62521183_tenti_e
treatise8311103treatise
uretic82914353ure_tic_

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.436409841.7
2DLD Change Limit1461621607.75018859.6
3Display Results1601600.0802000.0
 (SQL Overall)1786911608.26621617.6
 
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.