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 “utilities” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
utilities961080(None) 
futilities1348861futilities
abilities11714142abilities
agilities10810972agilities
anilities9516002anilities
ductilities1446202ductilities
humilities1547702humilities
inutilities1148182inutilities
motilities12410582motilities
nubilities1249722nubilities
subtilities1347852subtilities
utilises848972utili_ses
utilizes1758122utili_zes
acidities12810183acidities
activities1548903activities
aminities11312913aminities
analities9715873analities
aridities10911633aridities
auralities10410223auralities
avidities13107613avidities
axialities1747733axialities
brutalities1345443brutalities
civilities1547843civilities
cubicities1646823cubicities
cupidities1545973cupidities
cutabilities1649143cutabilities
debilities13411293debilities
dimities11314003_dimities
disutilities1355153disutilities
docilities1349003docilities
dualities10310443dualities
facilities1549823facilities
fatalities1349443fatalities
fertilities1448823fertilities
fetidities1447873fetidities
fixities1838213_fixities
futurities1345423futurities
gentilities1249133gentilities
hostilities14127653hostilities
humidities1645893humidities
jollities1647873jollities
kilties113014143_kil_ties
labilities12712233labilities
latinities10410163latinities
lucidities1346253lucidities
militias1048633_militias
mobilities1449833mobilities
motivities1547693motivities
mucidities1546233mucidities
mutabilities1649553mutabilities
mutilates11310953mutilat_es
mutualities1395833mutualities
natalities10410663natalities
nativities1348433nativities
nihilities1348663nihilities
nobilities12410643nobilities
nonutilities1256683nonutilities
nullities949353nullities
nuptialities1454783nuptialities
oralities91214123oralities
otiosities1046453otiosities
outcities1149513out_cities
outpities1148623out_pities
ovalities12119803ovalities
polities102722343_polities
privities14312043privities
puerilities1347533puerilities
putridities1444913putridities
qualities18311223qualities
realities9316313realities
ruralities1048573ruralities
rusticities1346843rusticities
sectilities1348693sectilities
senilities10312993senilities
stabilities13511783stabilities
sterilities11129013sterilities
stilbites1144833stilbit_es
stipites1039653stipit_es
stylites11168693stylit_es
suabilities13610813suabilities
subtilties1246113subtil_ties
tactilities1347673tactilities
tillites8312833_tillit_es
titties73617363_ti_tties
totalities101210783totalities
trinities9313343trinities
tumidities1345893tumidities
ubieties1046913ubi_eties
ubiquities2143223ubiquities
uglifies1246383u_glifies
unities72520153u__nities
uralites82112723uralit_es
usabilities1369013usabilities
utilidors1051963utilidors
utilise749063utili_se_
utilised956733utili_sed
utiliser855243utili_ser
utilisers953553utilisers
utilising1046633utilising
utility1038703utilit__y
utilize1648813utili_ze_
utilized1847553utili_zed
utilizer1756203utili_zer
utilizers1854553utilizers
utilizing1947803utilizing
uvulitis1142733uvuliti_s
uvulitises1342283uvulitises
vagilities1447953vagilities
vilifies1439593_vilifies
virilities1379123virilities
vitalities1349093vitalities

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.420425454.8
2DLD Change Limit1486411116.92321470.6
3Display Results1111110.0631761.9
 (SQL Overall)1786911117.40624127.9
 
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.