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

70 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
quadrat176927(None) 
quadrant1858081quadrant
quadrate1888041quadrate
quadrats1866481quadrats
quadrans1866362quadrans
quadrants1965362quadrants
quadrated2055912quadrated
quadrates19117802quadrates
quadratic2144522quadratic
quadric1946312quadric
quart144027852qua_r_t
carat75048793_ca_rat
drat56247833___drat
guardant1046443guardant
jurat124829323ju__rat
karat96837593_ka_rat
madras94316433_madras
mudcat11311203mu_dcat
mudra83912433mu_dra_
mudras94212263mu_dras
muskrat1346733muskrat
outdrag937003outdrag
outdraw1136903outdraw
qanat144426843q_a_nat
quad144618703quad___
quadded1934863quadded
quadrantal2052693quadrantal
quadrantes2054573quadrantes
quadratics2253583quadratics
quadrating2145653quadrating
quadrature2052533quadrature
quadrics2045653quadrics
quadriga1944073quadriga
quadrigae2053633quadrigae
quadroon1844473quadroon
quads154515843quad__s
quaere154110673quaer_e
quaeres163310843quaeres
quagga1754143quagga_
quaggas1893703quaggas
quaint15415173qua_int
qualia1559563qualia_
quandary2143433quandary
quant143624813qua__nt
quanta153911333quanta_
quantal16367893quantal
quare143920543qua_r_e
quark184614123qua_r_k
quarks193810913qua_rks
quarrel1636103quarrel
quarry1837473qua_rry
quartan1636423quartan
quarte154115323qua_rte
quartet162814893quartet
quarto153511123qua_rto
quarts154715933qua_rts
quartz244212103qua_rtz
quasar1536833qua_sar
quasars1646903quasars
quatrain1745823quatrain
quatre153512353quatr_e
quatres163411933quatres
quinnat16116823quinnat
quirt144624233qu_ir_t
squadron1843503squadron
tundra736423tundra_
tundras857113tundras
undraw1037813_undraw
updart9310743_updart
updraft1346033_updraft

Search took 7 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.403443402.0
2DLD Change Limit134027705.64323751.0
3Display Results70700.0302333.3
 (SQL Overall)178691706.07629409.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.