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

52 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
querida174435(None) 
queridas1843861queridas
queried1738692queried
querier16310012querier
queries16315872queries
querist16311132querist
aquaria1638043aquari_a
ceria75125363_ceri_a
clerid9312413clerid_
clerids1049093clerids
corrida1078523corrida
curia74523783cu_ri_a
deride84420033_deride
emerita938713emerita
erica7316543__erica
feria85922713_feri_a
gueridon1043033gueridon
guerilla943793guerilla
jerid132316423_jerid_
jerids142810943_jerids
lurid64618973lu_rid_
murid84520583mu_rid_
murids93212193mu_rids
nutria639913nutri_a
outride82615683outride
peridia10312373_peridia
puerile9310093puerile
purda82914693pu_r_da
putrid9311173putrid_
quadriga1944073quadriga
qualia1559563quali_a
queered17117223queered_
queering1838203queering
queerish2045313queerish
quelea1547303que_lea
quercine1964863quercine
queriers1736973queriers
querists1736543querists
quern143610403quer__n
querns15307943quer_ns
query174212083quer__y
querying2135243querying
queued16336943queued_
queuing1736233queuing
quid144922363qu__id_
quids154917473qu__ids
quinina16278143quinina
quired163711953quired_
quiring17159993quiring
taqueria1743413taqueri_a
uredia73610063_uredia
ureide7310363_ureide

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.423422437.4
2DLD Change Limit134027526.72019944.5
3Display Results52520.0163250.0
 (SQL Overall)178691527.15924960.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.