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

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

83 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
comates11412364(None) 
comakes154413641comakes
comate104124841comate_
comtes106222811com_tes
borates94823012borates
bromates12413142bromates
camases114216342camases
carates95630612carates
cates75951892c__ates
cerates95428252cerates
cholates132414762cholates
chromates16313112chromates
climates12311972climates
coated94927042co_ated
coatee84327222co_atee
coatees93816552co_atees
coater84329572co_ater
coaters93525792co_aters
coatis85122602co_atis
coats75635002co_at_s
coaxes154715632co_axes
cognates11311582cognates
coinmates1348342coinmates
collates103019142collates
comade114415322comade_
comae97128422coma_e_
comake144413422comake_
comaker153410602comaker
comakers16339172comakers
comas95833002coma__s
comatic131816932comatic
comatik15139722comatik
comatiks16148042comatiks
comatose1247822comatose
combated1539822combated
combater1439382combater
combaters1538112combaters
combats13311682combat_s
combes125321732com_bes
comes97246992com__es
comets105823582comet_s
comities12317792comities
commies133718452commies
commutes143011892commutes
compares143816432compares
competes144117242competes
compotes144716512compotes
compted143813522compted
compts125216652compt_s
computes143914552computes
comrades13149772comrades
comte96125472com_te_
conatus9310462conatus
contes84432912co_ntes
copemates1549482copemates
cotes76347842co__tes
cowages13310942cowages
coyotes12410702coyotes
crates85736062c_rates
creates95225202creates
cremates124216002cremates
curates95323832curates
donates83217222donates
folates103218452folates
fomites123613202fomites
formates132814292formates
hamates122917682hamates
homages131011582homages
humates122813192humates
inmates92715782inmates
iodates8312902iodates
locates93218812locates
mates75251362__mates
notates72817482notates
orates64328612_orates
pomaces132712122pomaces
pomades123711732pomades
remates93827112remates
rotates72819772rotates
solates73523852solates
somites94219122somites
stomates10313342stomates
tomatoes1038612tomatoes

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit107671833.50030763.1
3Display Results83830.0165187.5
 (SQL Overall)178691833.89245912.4
 
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.