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

71 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
question174582(None) 
questions1845521questions
egestion946862egestion
questing1838272questing
questioned2043182questioned
questioner1943042questioner
questor16146632quest_or
auction93412933au_ction
audition979173audition
bastion9312473_bastion
cession939813_cession
creation102816513creation
cushion1236403cu_shion
digestion1146573digestion
duration9312693duration
egestions1046703egestions
ejection172510043ejection
election102015353election
equation17310483equ_ation
equestrian1952683equestrian
erection102115513erection
evection131910833evection
exertion15310083exertion
festoon1037673_festoon
flection13239563flection
function1337843function
fusion939773fu_s_ion
fustian1036903fu_stian
guesting1058463guesting
gumption1343983gumption
ideation9310493ideation
ingestion10137483ingestion
junction1736203junction
lection92614863_lection
lesion64715063_les_ion
lunation8311923lunation
luxation1538233luxation
mention9314373_mention
mestino9411643_mestino
munition1038763munition
mutation101412883mutation
neuston736083neust_on
nutation81513103nutation
pulsation1137143pulsation
pulsion938393puls_ion
punition1038373punition
pupation1269503pupation
quaestor1743313quaest_or
quassin1645943quassi_n
quest144121323quest___
quested17168383quest_ed
quester161410023quest_er
questers17168763questers
questionary2352973questionary
questioners2052683questioners
questioning2153243questioning
questors17147013questors
quests153310353quest__s
quintin163810333quinti_n
quotation18146973quotation
ruction93611613ru_ction
section92515663_section
session739763_session
suasion739363suas_ion
suction93713043su_ction
sudation9310803sudation
suggestion1253013suggestion
teston6313303_test_on
testoon748373_testoon
tuition738823tu_ition
unction9310663_unction

Search took 8 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.406440125.6
2DLD Change Limit146162716.76621602.4
3Display Results71710.0302366.7
 (SQL Overall)178691717.20224811.3
 
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.