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 “prototyping” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
prototyping195385(None) 
prototypic1954772prototypi_c
photolyzing2953873photolyzing
prettying1536043pret_ty_ing
pretyping1764943pr__etyping
promoting1439923promot__ing
protocoling1654853protocoling
protonating1448593protonating
prototypal1752973prototyp_al
prototype1645663prototyp__e
prototyped1844283prototyp_ed
prototypes1745923prototyp_es
prototypical2162633prototypical
drooping12268804dro_o__ping
ferrotyping2052164ferrotyping
heliotyping2051844heliotyping
karyotyping2451344karyotyping
linotyping1642234_linotyping
phonotypies2154464phonotypies
photocopying2563744photocopying
photoing1439074photo___ing
photomapping2162474photomapping
photostating18135844photostating
phototype1946054phototyp__e
phototypes2046514phototyp_es
plotting113011014plot_t__ing
pooping123615444p_o_o__ping
portraying1645164portray_ing
pottering122612004p_ot_tering
potting103720894p_ot_t__ing
prattling1246304prat_t_ling
pretaping1439134pr__etaping
probating14311194probat__ing
proctoring1546674pro_ctoring
profiting1549984profit__ing
prologing1338954prolo__ging
prologizing2445234prologizing
prologuing1443864prolo_guing
prolonging1444804prolo_nging
promoing13310464promo___ing
prompting1637204prompt__ing
pronating12313764pronat__ing
pronouncing1652924pronouncing
proofing1439314pro_o__fing
proponing1439994propo__ning
proposing1439674propo__sing
propounding1744054propounding
propping122811674pr__o_pping
prorating12314284prorat__ing
prorogating1556064prorogating
proroguing1443124proro_guing
proselyting1743904proselyting
prostituting1573954prostituting
protecting151910214prot_ecting
protending1446814prot_ending
protesting131910254prot_esting
protocolling1753024protocolling
protracting1646934protracting
protruding1453634prot_ruding
provoking1935134provo__king
puttying1434954p_ut_ty_ing
retotaling1186884_retotaling
retyping14255614_r__etyping
robotizing2245554_robotizing
rooting83522434_ro_ot__ing
rootling9269954_ro_ot_ling
rotating92614554_rotat__ing
rototilling1252644_rototilling
rotting82919684_rot_t__ing
serotyping1643124_serotyping
stenotyping1752194stenotyping
trooping112710284tro_o__ping
trotting92510914trot_t__ing
uprooting1276904upro_ot__ing

Search took 10 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 Filter1786911488190.410435831.7
2DLD Change Limit148819749.06016425.9
3Display Results74740.0332242.4
 (SQL Overall)178691749.50318803.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.