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

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

36 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
trampolinists176130(None) 
trampolinist1662031trampolinist_
trampolinings1812822trampolinings
trampoliners1651443trampolin_ers
trampolines1543903trampolin__es
trampolining1751943trampolini_ng
mandolinists1552314_mandolinists
trampoline1444534trampolin___e
trampoliner1552314trampolin__er
trombonists1553054trombo__nists
alpinists1195795__alp__inists
apologists1348885__a_pologists
crayonists1544135cra_yo__nists
graphologists20123835graphologists
harmonicists1982625harm_onicists
harmonists15137125harm_o__nists
mammonists13144655_mammo__nists
mandolinist1453975_mandolinist_
masculinists16102625_masculinists
radiologists1497365_radiologists
teratologists1496595tera_tologists
timpanists1453665t_imp__anists
topologists1447865t__opologists
trailerists1153815tra__ilerists
tramlines1139845tram__lin__es
trampiest13227895tramp__i_est_
trampling1436975tramp_lin___g
trapezists2152925tra_p__ezists
traplines11310375tra_p_lin__es
trapnests1144435tra_p___nests
tribologists1546165tr_ibologists
trichologists1955425trichologists
trombonist1454045trombo__nist_
tympanists1743105t_ymp__anists
typologists1746815t__ypologists
violinists1344445___violinists

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 Filter1786911247900.406440125.6
2DLD Change Limit124790368.06315476.9
3Display Results36360.0162250.0
 (SQL Overall)178691368.48521059.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.