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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
commandeers1812318(None) 
commandeer17124111commandeer_
commanders17146681command_ers
commandeered2051412commandeered
commander16127402command_er_
commandery20134252command_ery
commandoes17255262commandoe_s
commenders17137142commend_ers
colanders1238013co_land_ers
comanagers1543833co_managers
commandants1853373commandants
commanded17136503command_e_d
commandeering2161563commandeering
commanderies1953383commanderies
commandment1753823commandment
commandments1852953commandments
commandos16245963command__os
commands15318823command___s
commencers18156373commen_cers
commender16167923commend_er_
commenters16139483commen_ters
commoners15339783common__ers
communers15338413commun__ers
corianders1344913coriand_ers
pomanders1436223po_mand_ers
bombarders17153204bombard_ers
bombardiers1851564bombardiers
calamanders1662914calamand_ers
candlers114214104c___andlers
chandlers15387674c__handlers
cofounders1643334cofound_ers
colander1139034co_land_er_
coleaders1237824colea_d_ers
comakers16339174co_ma__kers
comanager1444534co_manager_
comanages1446534co_manage_s
combaters1538114comba__ters
combiners15247944combin__ers
command14399214command____
commandable2053294commandable
commandant1754814command_ant
commandership2572014command_ership
commanding1845924command_ing
commando15275754command___o
commencer17147804commen_cer_
commences17139584commen_ce_s
commendams1644314commend_ams
commended17137014commend_e_d
commends15308464commend___s
commenter151410694commen_ter_
commingles1744094commingle_s
comminutes1685624comminute_s
committees1644064committee_s
commodes1539094comm_od_e_s
commodores1743974comm_odores
commonages1745914commonage_s
commoner142710634common__er_
commonness1644364common_ness
commonweals20112294commonweals
communer14349304commun__er_
communes143411244commun__e_s
communises1646564communise_s
communizes2546254communize_s
commuters15378914comm__uters
comonomers1644524co_monomers
compacters18247034compa_cters
compadres16266414compa_dre_s
companies15311804compan_ie_s
comparers15319394compa__rers
compeers143410014co_m__peers
compounders1843144compound_ers
comradery1793494comra_d_ery
comrades13149774comra_d_e_s
contenders1348624contend_ers
coriander1245664coriand_er_
coromandels1652064coromand_els
cotransfers1672654cotransfers
cymbaleers1951414cymba_leers
demanders13247574_demand_ers
domineers1244674do_min_eers
germanders1444604germand_ers
goosanders1242864goosand_ers
gormandizers2562664gormandizers
lowlanders1442694lowland_ers
meanderers1343804__meanderers
meanders1168834__meand_ers
oleanders1035574_oleand_ers
pomander1347084po_mand_er_
recommenders1952124recommend_ers
romancers1345734ro_man_cers
solanders1036964so_land_ers
womanizers2444174wo_manizers

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit148819928.92316678.1
3Display Results92920.0462000.0
 (SQL Overall)178691929.38919032.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.