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

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

79 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
capitol11258281capitol
capita102913772capit_a
capital112311522capital
capitols12247332capitols
caption113513692caption
captor104914602cap_tor
atom67824523_a__tom
axiom143913593_axi_om
baptism1337803baptism
calico103414433calico_
calicos113913493calicos
camion103917193cami_on
campion133011413campi_on
canto74931013ca_nto_
canton85722993ca_nton
cantor85621523ca_ntor
cantos84826973ca_ntos
capacitor1543473capacitor
capias10318353capi_as
capitals12209443capitals
capitate121712183capitate
capitula1244983capitula
capitulum1551993capitulum
capiz18514563capi__z
capizes20410373capizes
capo85829213cap__o_
capon95221873cap__on
capos94826073cap__os
capote10315733capot_e
capotes11314643capotes
capsicum1643533capsicum
capstan1137903capstan
capstone1237653capstone
captan101613343cap_tan
captions123813223captions
captious122810573captious
captive1438973captive
captors113914983cap_tors
caput9823983caput__
caribou1156993caribou
caritas93316953caritas
carom95025563ca__rom
carrom10513403ca_rrom
carton84522663ca_rton
cartop104213563ca_rtop
casino84317553casino_
casinos93512833casinos
casita82913703casit_a
casitas93312043casitas
castor84418533ca_stor
cation83925503cati_on
caution93013523caution
cavity14310013cavit_y
chapiter1536603chapiter
chiton112612393c_hiton
chrisom1466623chrisom
cogito939203cogito_
cogitos1037613cogitos
copilot11811263copilot
custom104010273c_ustom
epitome1157743_epitome
fantom112110803fa_ntom
halidom1386443halidom
janitor1436483janitor
laptop1076813lap_top
madtom1138023ma_dtom
manito8518693manito_
manitos9314053manitos
manitou938463manitou
naphtol12124023naphtol
napiform1543763napiform
papadom1466763papadom
papism122211513papi_sm
piton76121583__piton
raptor83912823rap_tor
tapetum1145393tapetum
taproom1147963taproom
wapiti1138363wapit_i
wapitis1236473wapitis

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.1701051123.5
2DLD Change Limit134027796.39020974.5
3Display Results79790.0332393.9
 (SQL Overall)178691796.59327103.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.