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

48 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
minorcas124597(None) 
minorca1145221minorca_
minors85117102minor__s
binocs1039923bino_c_s
divorces1445673divorces
fincas113512073fin__cas
ixoras1337193_ixor_as
kinaras1159123kinar_as
maniocas12298473maniocas
manorial10311083manorial
manors84420883manor__s
mantras93815863mantr_as
menorah1247933menor_ah
menorahs1346543menorahs
micas96823053mi___cas
microcap1645583microcap
milords10117853milor_ds
mimosas1136753mimo_sas
minarets1048843minarets
minas75434113min___as
minces104420803min__ces
mineral9312733miner_al
minerals10311373minerals
miners84126633miner__s
minicab13177173min_icab
minicabs14135073min_icabs
minicam131110063min_icam
minicams14126873min_icams
minicar11109323min_icar
minicars12118523min_icars
minor74920063minor___
minored10310103minor_ed
minoring11311473minoring
minority1347933minority
mirzas1738183mi__rzas
monarchs1544833monarchs
monardas1145713monardas
monocrat12410783monocrat
monocrats1348533monocrats
moras76438783m__or_as
motorcar1274543motorcar
motorcars1394473motorcars
norias65518203__norias
orcas75918623___orcas
senoras72714953senor_as
signoras9306553signor_as
sinopias1047873sinopias
vincas113912453vin__cas

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 Filter1786911461620.436409841.7
2DLD Change Limit146162487.17320376.7
3Display Results48480.0133692.3
 (SQL Overall)178691487.62223444.1
 
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.