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

179 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
circuses123825(None) 
airbuses1067072airbuses
arcuses94814692_arcuses
carcases12313082carcases
carouses10614502carouses
caucuses1236782caucuses
cercises12410932cercises
cereuses1049242cereuses
ceruses93716232cer_uses
circles1139902circ_les
circuits1246022circuits
circus104310592circu__s
circusy14374592circus_y
cirques1836462cirqu_es
cistuses1038282cistuses
citruses1037482citruses
cornuses10310032cornuses
corpuses12310062corpuses
crocuses1239022crocuses
cruses88127712c_r_uses
cuscuses1235862cuscuses
discuses113112862discuses
ficuses12159202fi_cuses
incuses93514852_incuses
viruses1039412vir_uses
abacuses1235763abacuses
accuses114112193_accuses
airbusses1153613airbusses
arguses84711743_arguses
arouses74921293_arouses
berceuses1344103berceuses
birches143412323birc_hes
birses84717733bir__ses
cactuses1237933cactuses
calluses1039323calluses
campuses1437773campuses
carcase11312733carcase_
carcass11310513carcas_s
carcasses1337473carcasses
cardcases1446493cardcases
caresses10314063caresses
caroluses1157613caroluses
carouse9614423carouse_
caroused1149253caroused
carousel1057313carousel
carousels1165343carousels
carouser1068843carouser
carousers1156733carousers
carses85233653car__ses
caucused1344093caucused
caucusses1343043caucusses
causes88026473c__auses
cayuses12188403c_ayuses
censuses10187543censuses
cercus105013153cercu__s
cerises94722253cer_ises
ceruse83914523cer_use_
cestuses1038083cestuses
chiauses1336483chiauses
choruses1339983choruses
chouses125117813c_houses
ciboules1244533ciboules
cinches144215773cinc_hes
cinctures1346063cinctures
cinques1837333cinqu_es
circle1039703circ_le_
circled1237583circ_led
circler1136423circ_ler
circlers1235353circlers
circlet11311473circ_let
circlets1235663circlets
circuit1148833circu_it
circuited1444563circuited
circuities1446913circuities
circuity1544963circuity
circular1247903circular
circulars1346543circulars
circulates1489283circulates
circumcises1683933circumcises
circumfuses20103373circumfuses
cires74932913cir___es
cirque1735853cirqu_e_
cirrhoses1443883cirrhoses
cirrose937473cirrose_
cirrus8349173cirru__s
ciscoes113610733cisc_oes
clauses93813323c_lauses
clonuses1057133clonuses
coituses1039623coituses
coleuses1039723coleuses
concuss1138063concus_s
concusses1346343concusses
confuses13310363confuses
contuses10413453contuses
corpses113913803cor_pses
corses84433463cor__ses
crases85532313c_r_ases
creases94020963c_reases
creeses93914623c_reeses
cresses94219813c_resses
crises84529433c_r_ises
crosses94220793c_rosses
croupes114613103c_roupes
crouse84619363c_rouse_
croutes94815653c_routes
cruces105117543c_r_uces
crudes96218623c_r_udes
cruises93514443c_ruises
cruse75726103c_r_use_
cruset84425093c_r_uset
crusets93811043c_r_usets
crushes124215133c_r_ushes
crusts84916543c_r_usts
cruxes154911563c_r_uxes
cuirasses1144373cuirasses
cultuses1037753cultuses
curches143512743curc_hes
curcumas1454853curcumas
curses85328273cur__ses
cycases1437533c_ycases
cypruses1534313cypruses
diffuses1534823diffuses
dinguses1037643dinguses
dioceses1137113dioceses
discases112014503discases
discuss10357953discus_s
discusses12268253discusses
diseuses93112763diseuses
disuses84015413di_suses
druses75517253_dr_uses
excuses1638903_excuses
focuses12159653_focuses
fucuses12158353_fucuses
grouses84616543_grouses
hercules1337633hercules
hiatuses1135773hiatuses
hocuses121710423_hocuses
ictuses938303_ictuses
ileuses738673_ileuses
incases93615973_incases
incises93414893_incises
incudes10319523_incudes
incuse83513573_incuse_
incused102911173_incused
infuses102711873_infuses
irises64221173_ir_ises
limbuses1234903limbuses
litmuses1044463litmuses
minuses93512703mi_nuses
miscues11312393miscu_es
missuses10309683missuses
misuses93216023mi_suses
mucuses11148513_mucuses
narcoses103910543narcoses
niduses837013ni_duses
nimbuses1244663nimbuses
percuss1137163percus_s
percusses1346503percusses
perfuses1358663perfuses
peruses94018163per_uses
primuses1237083primuses
recuses94619463_recuses
reuses66025523__reuses
rhuses94911793__rhuses
rictuses1037563rictuses
risuses73210923ri_suses
rouses65436283__rouses
ruses56136583__r_uses
scirrhuses1551463scirrhuses
sinuses73011593si_nuses
situses72710493si_tuses
uprouses1037553uprouses
uruses63616503_ur_uses
varuses10310623var_uses
virgules1244333virgules
viroses10310533vir_oses
virtues10338023virtu_es
viscoses1338343viscoses
xeruses143010753xer_uses

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.423422437.4
2DLD Change Limit1461621796.59322169.3
3Display Results1791790.0762355.3
 (SQL Overall)1786911797.09225196.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.