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

66 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
errancies114796(None) 
aberrancies1593912aberrancies
errantries1044942errantries
inerrancies1355052inerrancies
truancies1146882truancies
verdancies1645232verdancies
aberrances1475433aberranc_es
ardencies1247853ardencies
arranges939413arran_ges
arrogancies1454073arrogancies
branches153613803_branches
brandies11714563_brandies
cranches153114543_cranches
crannies10313013_crannies
curacies12311763cura_cies
currencies1445663currencies
deviancies1644593deviancies
dormancies1565413dormancies
durances1158683duranc_es
earaches13411313eara_ches
elegancies1345013elegancies
enhances1339293enhanc_es
entrances11310953entranc_es
errancy1256363erranc__y
errands847603erran__ds
errants7410643erran__ts
erratics1046983erra_tics
estancias1145003estancias
fancies124018783__fancies
fervencies1845183fervencies
fragrancies1753303fragrancies
francizes2346793_francizes
geomancies1545743geomancies
grannies9312613_grannies
infancies1446973infancies
irritancies1353343irritancies
mordancies1544703mordancies
nancies93516843__nancies
organdies1187213organdies
peccancies1544933peccancies
piracies12312643pira_cies
pliancies1346673pliancies
prances113618773_pranc_es
rances84625443__ranc_es
ranches123620113__ranches
randies84225663__randies
rebranches1745193rebranches
recencies13312253recencies
recreancies1544653recreancies
regencies1249283regencies
regnancies1345413regnancies
revanches1746253revanches
sergeancies1444393sergeancies
serranids1045533serran_ids
tenancies1149173tenancies
terraces102712253terra_c_es
terranes82514433terran__es
trances93919643_tranc_es
tranches132915513_tranches
trannies8415013_trannies
tyrannies1255533tyrannies
urgencies1256643urgencies
vacancies1645493vacancies
vagrancies1644173vagrancies
vibrancies1744413vibrancies
warranties1344683warranties

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 Filter1786911486410.453394461.4
2DLD Change Limit148641666.81321817.3
3Display Results66660.0302200.0
 (SQL Overall)178691667.29624491.6
 
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.