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

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

85 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
quants15361414(None) 
quant143624811quant_
quanta153911331quanta
quarts154715931quarts
quints154316561quints
alants67722022alants
ants47243472__ants
aunts55227632au_nts
brants85723052brants
bunts75729802bu_nts
cants77036942_cants
chants115020392chants
cunts76125122cu_nts
daunts75014082daunts
dunts65828412du_nts
eluants737582eluants
giants74713502giants
grants73722472grants
guanos73811992guanos
guans64419442guan_s
hants86335402_hants
haunts95614392haunts
hunts86826172hu_nts
jaunts137511882jaunts
jurants14379212jurants
lunts55826902lu_nts
mutants938582mutants
pants76536922_pants
plants84921802plants
punts75828002pu_nts
qanats154112812q_anats
qats135331342q_a_ts
quacks214710102quacks
quads154515842qua_ds
quaffs21125692quaffs
quags154613252qua_gs
quails153412642quails
quaint15415172quaint_
quais144618392qua_is
quakes194013342quakes
qualms17317242qualms
quango1636492quango
quangos1734652quangos
quantal16367892quantal
quanted1738962quanted
quantic18279062quantic
quantics19276832quantics
quantum1845102quantum
quarks193810912quarks
quart144027852quart_
quarte154115322quarte
quartes163314932quartes
quarto153511122quarto
quartos16328732quartos
quartz244212102quartz
quass144413762qua_ss
quate144521412qua_te
quays174612042qua_ys
qubits173710352qubits
queans153110752quean_s
quests153310352quests
quiets154014372quiets
quilts154112542quilts
quins144819852quin_s
quint144529902quint_
quinta153312372quinta
quintas163611712quintas
quinte153414522quinte
quintes164114712quintes
quirts154213552quirts
quits144122352qu_its
quoits15379682quoits
rants55935342_rants
ruanas6311262ruanas
runts55927632ru_nts
scants85219722scants
slants64819082slants
squats153712962squa_ts
squints16339032squints
suints64617782suints
taunts65715662taunts
truants738162truants
vaunts95212622vaunts
wants87932212_wants
yuans84613322yuan_s

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551852.14038575.2
3Display Results85850.0165312.5
 (SQL Overall)178691852.49971505.0
 
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.