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

118 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
prologing133895(None) 
prologuing1443861prologuing
prolonging1444801prolonging
progging132610382pro_gging
prologist12315082prologist
prologize2147962prologize
prologizing2445232prologizing
prolong10319632prolo__ng
promoing13310462promo_ing
promoting1439922promoting
pronging123511842pro_nging
proofing1439312pro_ofing
proponing1439992proponing
proposing1439672proposing
proroguing1443122proroguing
provoking1935132provoking
brooding122911373bro_oding
brooking153710703bro_oking
brooming132911143bro_oming
coloring11414843_coloring
crooking153611343cro_oking
crooning113112113cro_oning
dialoging1246313dialoging
drolling103510763drol_ling
drooling102610423dro_oling
drooping12268803dro_oping
frogging14358733fro_gging
grooming12309513gro_oming
grooving13286713gro_oving
orologies10311623orologies
orologist10313103orologist
paroling113316213parol__ing
photoing1439073photo_ing
pillaging1345573pillaging
pillowing1545493pillowing
piloting1139693p_iloting
plowing133111723p__lowing
ploying132811573p__loying
policing13311673p_olicing
poling93526503p_ol__ing
polkaing1534633p_olkaing
polling102920383p_ol_ling
ponging113416153p_o_nging
poohing133112323p_o_ohing
pooing93820683p_o_o_ing
pooling103219093p_o_oling
pooping123615443p_o_oping
portaging1346843portaging
pranging123012723pr_anging
precoding15109733precoding
preloading1446583preloading
preluding1337053preluding
presaging1339393presaging
prigging13299093pr_igging
prilling113413413pril_ling
prisoning1237643prisoning
probating14311193probating
probing123314443pr__obing
proctoring1546673proctoring
procuring1437993procuring
prodding13189343pro_dding
producing1556143producing
profaning1537293profaning
profiling1548233profiling
profiting1549983profiting
prognosing1444423prognosing
prolamin12139753prolamin_
prolamine131510563prolamine
prolamins13159703prolamins
prolapsing1543873prolapsing
proline92321593prol__ine
prolog94212973prolo___g
prologed12189213prolog_ed
prologists13311173prologists
prologized2346103prologized
prologizes2248113prologizes
prologs103512133prolog__s
prologue1146833prolog_ue
prologued1344663prologued
prologues1246903prologues
prologuize2252943prologuize
prologuizing2552443prologuizing
prolonge11388403prolo__nge
prolongs11347613prolo__ngs
promising14410973promising
prompting1637203prompting
promulging1642683promulging
pronating12313763pronating
propining14310133propining
propping122811673pro_pping
prorating12314283prorating
prorogating1556063prorogating
prosing103319383pr__osing
providing1637963providing
proving134214073pr__oving
prowling1449993pro_wling
pyrolizing2546843pyrolizing
pyrologies16310013pyrologies
pyrolyzing2843253pyrolyzing
rolfing113710653_rol_fing
rolling83620413_rol_ling
roofing113814353_ro_ofing
rooking123517363_ro_oking
rooming104117043_ro_oming
roosing84018133_ro_osing
rooting83522433_ro_oting
rouging93114703_ro_uging
soloing82813803_solo_ing
stooging102810043sto_oging
trolling93212493trol_ling
trollying1354053trollying
trooping112710283tro_oping
uprooting1276903upro_oting
urologic1147343urologi_c
urologies1039533urologies
urologist10411053urologist
vrooming14287353vro_oming
wronging13327393wro_nging

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.420425454.8
2DLD Change Limit1486411187.75019179.5
3Display Results1181180.0631873.0
 (SQL Overall)1786911188.23321704.2
 
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.