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

141 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
civisms143607(None) 
civism1337241civism_
activisms16106392activisms
chrisms1499142chrisms
civicisms18134822civicisms
civics13397822civi_cs
civies114116442civi_es
cubisms13306882cubisms
favisms1535442favisms
actinisms1398883actinisms
activism15117083activism_
activists1497043activists
advises11138973advises
ageisms1056603ageisms
agisms9399393_agisms
animisms12328393animisms
atavisms1346993atavisms
autisms94311553autisms
avisos95410483_avisos
cambisms1645803cambisms
camisas113411923camisas
camises114218463camises
caviars1238623caviars
cavies114525003cavi_es
cavils114014393cavi_ls
cavings134712543cavings
cerises94722253cerises
ceriums1139473ceriums
cesiums1136303cesiums
chaises124317493chaises
charisms15710263charisms
chasms135513143c_hasms
chemisms17278213chemisms
chiasms14357523chiasms
chiliasms1693493chiliasms
chirms135113983c_hirms
chivies153412853chivi_es
chrism13710673chrism_
chrisma1456823chrisma
chrisoms1566093chrisoms
cilices113814023cilices
cilium104311373cilium_
cimices13279803cimices
cissies94116153cissies
cists76624533c__ists
cities84524853citi_es
civets115212543civ_ets
civic123412543civi__c
civicism17105353civicism
civie103716353civi__e
civil103411933civi__l
civilise1386263civilise
civilises14106093civilises
civilly1535483civilly
civvies1555843civvies
cladisms1336093cladisms
claims105211573clai_ms
clevises1336903clevises
clivias1266693clivi_as
clonisms1237793clonisms
coniums11311863coniums
cosmisms1446223cosmisms
covings134511243covings
covins114618063covi_ns
crises84529433c_rises
crisis83716343c_risis
crisps104411513c_risps
cruises93514443cruises
cubism12348703cubism_
cubists11359023cubists
cultisms12126713cultisms
curiums1138503curiums
cutises94414913cutises
cynicisms1844643cynicisms
czarisms2155753czarisms
deisms94411043_deisms
devises114116763devises
divests114510933divests
divides123211453divides
divines113514723divines
divisor11345573divisor
divisors12255693divisors
echoisms1546143echoisms
egoisms1065953egoisms
elitisms1048193elitisms
eonisms92811043eonisms
fauvisms1643743fauvisms
favism1437913favism_
fideisms1444453fideisms
finises10312903finises
holisms123811113holisms
ibises83610543_ibises
idioms956413_idioms
iodisms10308483iodisms
irises64221173_irises
isms66213473___isms
ivies84215763_ivi_es
jisms14458003__jisms
kilims1277903kili_ms
laicisms1247123laicisms
liaises7311053liaises
liviers104211073liviers
livings11408923livings
lyrisms1235653lyrisms
mavises122812993mavises
miasms1097383mi_asms
minims104514813mini_ms
miniums113910223miniums
mitises9315543mitises
momisms10308223momisms
monisms113512803monisms
mutisms11338453mutisms
nanisms938833nanisms
nativisms14105993nativisms
nomisms11268743nomisms
nudisms10305853nudisms
obiisms1135673obiisms
ogrisms1036443ogrisms
pacifisms1845093pacifisms
papisms13238543papisms
pavises125315493pavises
pianisms1249013pianisms
pietisms1247463pietisms
porisms113713453porisms
prisms104915503_prisms
purisms114110833purisms
qiviuts1942893qiviuts
racisms112310813racisms
revises104220533revises
sadisms10359113sadisms
schisms1437173schisms
sciolisms1346223sciolisms
seisms84912143_seisms
sexisms16226223sexisms
theisms1237763theisms
truisms9106823truisms
verisms123011253verisms
vibists1256483vibists
vims95423313__vi_ms
visas84317653__visas
vises84427773__vises

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.420425454.8
2DLD Change Limit1340271415.92322628.2
3Display Results1411410.0632238.1
 (SQL Overall)1786911416.40627894.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.