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

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
quantum184510(None) 
quant143624812quant__
quanta153911332quant_a
quantal16367892quantal
quanted1738972quanted
quantic18279062quantic
quants153614142quant_s
antrum8611313__antrum
aquanaut1744313aquanaut
aquarium1945383aquarium
bantam10314063_bantam
bunkum1435983bu_nkum
cantus85117763_cantus
centum104012363_centum
cranium11911103cranium
cundum1136513cu_ndum
datum8310633_da_tum
dubnium1244183dubnium
fantom112110803_fantom
fanum10313443_fan_um
granum9310913gran_um
mantua84412023_mantua
mentum104511713_mentum
muonium1146863muonium
omentum1155933omentum
pantoum1138703_pantoum
phantom1436693phantom
quahaug2042473quahaug
quaint15415173quaint__
quainter1765903quainter
quaintly2065023quaintly
qualm163511183qua__lm
quango1636493quan_go
quangos1734653quangos
quantics19276833quantics
quantify2343863quantify
quantile1747323quantile
quanting1849233quanting
quantity2044733quantity
quantize2645963quantize
quantong1843493quantong
quart144027853quart__
quartan1636433quartan
quarte154115333quart_e
quarter163211863quarter
quartes163314943quartes
quartet162814903quartet
quartic18258473quartic
quarto153511123quart_o
quartos16328743quartos
quarts154715943quart_s
quartz244212103quart_z
quate144521413qua_t_e
quatre153512363qua_tre
quietus16286393quietus
quint144529903quint__
quinta153312373quint_a
quintal16389883quintal
quintan16399223quintan
quintar16478603quintar
quintas163611713quintas
quinte153414523quint_e
quintes164114713quintes
quintet163914453quintet
quintic18308883quintic
quintin163810333quintin
quints154316563quint_s
quondam1943303quondam
quorum1736023qu_orum
sanctum1145293_sanctum
santur6311273_santur
stannum944643stannum
tantrum946683_tantrum
uranium9610023uranium

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 Filter1786911340270.406440125.6
2DLD Change Limit134027746.84319586.0
3Display Results74740.0302466.7
 (SQL Overall)178691747.27924548.8
 
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.