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

69 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
questions184552(None) 
question1745821question_
egestions1046702egestions
questing1838272questi_ng
questioned2043182questioned
questioner1943042questioner
questioners2052682questioners
questors17147012quest_ors
auctions104012143au_ctions
auditions1078753auditions
bastions10411693_bastions
cessions1039853_cessions
creations112614543creations
cushions1335693cu_shions
digestions1246403digestions
durations10311463durations
egestion946863egestion_
ejections18249963ejections
elections112414973elections
equations1839493equ_ations
equestrians2052403equestrians
erections112515213erections
evections142510693evections
exertions1639763exertions
festoons1136443_festoons
flections14239213flections
functions1437743functions
fusions1039153fu_s_ions
fustians1146403fu_stians
guesting1058463guesti_ng
gumptions1443773gumptions
ideations1039903ideations
ingestions1197593ingestions
junctions1835943junctions
lections102413843_lections
lesions73813873_les_ions
lunations9310723lunations
luxations1637273luxations
mentions10312893_mentions
mestinos1048163_mestinos
munitions1138173munitions
mutations111211453mutations
neustons836833neust_ons
nutations91411763nutations
pulsations1236373pulsations
pulsions1037713puls_ions
punitions1137923punitions
pupations1338123pupations
quaestors1843613quaest_ors
quassins1735793quassi_ns
questers17168763quest_ers
questionary2352973questionary
questioning2153243questioning
questionless2152003questionless
questor16146633quest_o_r
quests153310353quest___s
quintins17329863quinti_ns
quotations19146283quotations
ructions102811683ru_ctions
sections102714703_sections
sessions839723_sessions
suasions838783suas_ions
suctions103012903su_ctions
sudations1039903sudations
suggestions1353053suggestions
testons7313563_test_ons
testoons837323_testoons
tuitions838283tu_itions
unctions1039733_unctions

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 Filter1786911486410.406440125.6
2DLD Change Limit148641696.70322175.3
3Display Results69690.0302300.0
 (SQL Overall)178691697.13925030.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.