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

96 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
pretyping176494(None) 
pretaping1439131pretaping
retyping14255611_retyping
prepping12309762pre_pping
prettying1536042prettying
preying133114552pre_y_ing
retaping113012552_retaping
retying113213832_rety_ing
creeping133310103cre_eping
creping122913653cre__ping
fretting122711523fret_ting
greying124110893gre_y_ing
mistyping1744723mistyping
partying14168893party_ing
peeping123615213p_e_eping
pepping113511623p_e_pping
petering112516813p_etering
petnaping1444543p_etnaping
petting103720953p_et_ting
pettling1168213p_ettling
pitying132910243p_ity_ing
poetising1238713poetising
poetizing2148683poetizing
prating103424453prat__ing
prattling1246303prattling
praying133717323pr_ay_ing
preaching172811163preaching
preacting142412533preacting
prearming14139223prearming
prebaking1838063prebaking
prebuying1734303prebuying
preceding15129363preceding
precising14413273precising
precoding15109733precoding
precuring1439423precuring
predating13514653predating
predrying1645343predrying
preeing103817673pre__eing
preempting1745393preempting
preening113115843pre_ening
prefacing17118743prefacing
prefading16149033prefading
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
prehiring1548383prehiring
preluding1337053preluding
premising14412413premising
premixing2157803premixing
prenticing1547883prenticing
preparing14311643preparing
prepaving1787233prepaving
prepaying1747973prepaying
presaging1339393presaging
preshaping1845423preshaping
presiding13510903presiding
pressing112516443pre_ssing
prestamping1863653prestamping
prestoring13310303prestoring
presuming1437663presuming
pretasting13239283pretasting
pretelling1338143pretelling
pretending1438613pretending
pretesting131810683pretesting
pretexting20206973pretexting
pretrain10310923pretrain_
pretrains11410143pretrains
pretype14387483pretyp__e
pretyped16306123pretyp_ed
pretypes15337263pretyp_es
prevising15510873prevising
prevuing1457253pre_vuing
prewiring1547893prewiring
primping15338893pr_imping
propping122811673pr_opping
prototyping1953853prototyping
prying124114803pr__y_ing
puttying1434953putty_ing
reaping103621213_re_aping
redyeing1336173_redyeing
relying112914613_rely_ing
repping123314983_re_pping
restyling1337923_restyling
retaking133114283_retaking
retaxing162311333_retaxing
retching143412173_retching
retieing92913713_retieing
retiling93319483_retiling
retiming113014193_retiming
retiring92717413_retiring
retrying122410453_retrying
retting83425883_ret_ting
retuning9311583_retuning
serotyping1643123serotyping
teletyping1642473teletyping
typing124110583___typing

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.406440125.6
2DLD Change Limit148641967.53019739.8
3Display Results96960.0332909.1
 (SQL Overall)178691967.96922423.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.