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

166 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
citruses103748(None) 
ceruses93716232c_eruses
choruses1339982choruses
circuses1238252circuses
cistuses1038282cistuses
citrates102315092citrates
citrines102513132citrines
citrus83610922citru__s
citrusy12284182citrus_y
coituses1039622coit_uses
cruses88127712c__ruses
cypruses1534312cypruses
estruses838482estruses
icteruses1144972icteruses
ictuses938302ict_uses
litmuses1044462litmuses
situses72710492sit_uses
viruses1039412vi_ruses
airbuses1067073airbuses
birses84717733bi_r_ses
cactuses1237933cactuses
calluses1039323calluses
campuses1437773campuses
carouses10614503carouses
carses85233653c_ar_ses
cathouses1439433cathouses
caucuses1236783caucuses
causes88026473c__auses
cayuses12188403c_ayuses
censuses10187543censuses
cereuses1049243cereuses
cerises94722253c_erises
ceruse83914523c_eruse_
cestuses1038083cestuses
charases131312763charases
chiauses1336483chiauses
chorused1446133chorused
chorusses1444883chorusses
chouses125117813c_houses
ciboules1244533ciboules
cinques1837333cinqu_es
circles1139903ci_rcles
cires74932913ci_r__es
cirques1836463ci_rques
cirrhoses1443883cirrhoses
cirrose937473cirrose_
cirrus8349173cirru__s
cites74435593cit___es
cities84524853cit__ies
citifies13310683citifies
citoles9312553cit_oles
citrals91111673citr_als
citrate92216803citrate_
citrated112712253citrated
citreous1056853citreous
citrine92514023citrine_
citrins92614363citr_ins
citrons92913223citr_ons
citrous93112993citr_ous
clauses93813323c_lauses
clitorises1246113clitorises
clonuses1057133clonuses
coleuses1039723coleuses
confuses13310363confuses
contuses10413453contuses
cornuses10310033cornuses
corpses113913803c_orpses
corpuses12310063corpuses
corses84433463c_or_ses
cotrustee1145583cotrustee
cotrustees1243323cotrustees
courses94218893cour_ses
crases85532313c__rases
crises84529433c__rises
crocuses1239023crocuses
cruces105117543c__ruces
crudes96218623c__rudes
cruises93514443c__ruises
cruse75726103c__ruse_
cruset84425093c__ruset
crusets93811043c__rusets
crushes124215133c__rushes
crusts84916543c__rusts
cruxes154911563c__ruxes
cultuses1037753cultuses
curses85328273c_ur_ses
cuscuses1235863cuscuses
cutises94414913cut_ises
cutlases1038033cutlases
cutpurses1343313cutpurses
cypreses1535143cypreses
detrudes1036203detrudes
diereses938693diereses
diestruses1164503diestruses
diffuses1534823diffuses
dinguses1037643dinguses
discuses113112863discuses
diseuses93112763diseuses
distrusts1046523distrusts
disuses84015413di_suses
diureses936453diureses
druses75517253__druses
enthuses1138253enthuses
entrusts847113entrusts
extrudes1645243extrudes
fetuses10310243fet_uses
fibroses1345973fibroses
ficuses12159203fi_cuses
hiatuses1135773hiatuses
hidroses1237903hidroses
ileuses738673_ileuses
incuses93514853_incuses
infuses102711873_infuses
inrushes1136273_inrushes
intrudes937493intrudes
intrusts837723intrusts
irises64221173_i_rises
limbuses1234903limbuses
litres65220393litr__es
lotuses74011253lot_uses
minuses93512703mi_nuses
misrules1039383misrules
missuses10309683missuses
mistrusts1146013mistrusts
misuses93216023mi_suses
mitises9315543mit_ises
mitoses9312183mit_oses
mitres83922073mitr__es
niduses837013ni_duses
nimbuses1244663nimbuses
nitrates82516223nitrates
nitres65519333nitr__es
nitrides92910703nitrides
nitriles8269923nitriles
nitrites82313453nitrites
obtrudes1144073obtrudes
oestruses946403oestruses
outrushes1246653outrushes
overuses11312643overuses
peruses94018163_peruses
rictuses1037563rictuses
risuses73210923ri_suses
ruses56136583___ruses
scirrhuses1551463scirrhuses
sinuses73011593si_nuses
titrates82314663titrates
titres64718933titr__es
touses64229673__touses
truces84916333__truces
trues54925323__tru_es
truss54916923__trus_s
trusses73813643__trusses
trusts64714433__trusts
unitrusts943323unitrusts
untruss736553untrus_s
untrusses945703untrusses
uruses63616503__uruses
uteruses837183uteruses
varuses10310623_varuses
viroses10310533vi_roses
virtues10338023virtu_es
vitesses1136333vitesses
vitreouses1343003vitreouses
vitrines112610913vitrines
walruses11554973walruses
xeruses143010753_xeruses

Search took 9 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.420425454.8
2DLD Change Limit1461621668.00318263.4
3Display Results1661660.0602766.7
 (SQL Overall)1786911668.48321064.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.