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

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

91 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
representation1615412(None) 
representations17153891representations
presentation1448992__presentation
representative19192312representative
presentations1548133__presentations
reorientation1375593reor_ientation
representatives20211893representatives
depigmentation20103044depigmentation
fermentation1756824fe_r_mentation
implementation2063154implementation
presentational1673214__presentational
presentative1755344__presentative
preservation1776284__preservation
reforestation1654574refores__tation
regimentation1695434re_gimentation
reorientations1465214reor_ientations
replantation1445524rep__lantation
reprehension1753374reprehen__sion
representable17102334representa_ble
representing1555134represen__ting
repristination16204104repristination
revegetation16105304re_vege_tation
assentation1146195___assentation
cementation1559705___cementation
complementation2392695complementation
decrepitation1884805decre_pitation
deforestation1754305defores__tation
depigmentations21102845depigmentations
deprecation1648965depr__e_cation
depreciation1747075depr__eciation
depredation1546925depr__e_dation
detestation1248365de_tes__tation
experimentation2662715experimentation
fermentations1856275fe_r_mentations
forestation1447005_fores__tation
frequentation2552635fre__quentation
impersonation1764225imperson_ation
implementations2162885implementations
impregnation1754015impre_gn_ation
necessitation15123095ne_cessitation
orientation1147575__or_ientation
perennation1348085__p_erennation
personation1349485pe_r_son_ation
pigmentation1754485__pigmentation
placentation1694155__placentation
premeditation1855705__premeditation
preselection16154885__preselection
preservations1895545__preservations
preventative2054315__preventative
prevention1549175__preven__tion
protestation1456365__protestation
recantation1349865___recantation
recommendation2183225recommendation
reconcentration1963995reconcentration
reconsecration1885565reconsecration
recreation12413615recr__e__ation
recrimination1757405recrimin_ation
reescalation1464085re__escalation
reforestations1754465refores__tations
refrigeration1764155refrige_ration
regeneration1348195re_gene_ration
regimentations1784855re_gimentations
reimplantation1861935reimplantation
reinfestation1664255re_infestation
rejuvenation22123005re_juven_ation
reorchestration2072835reorchestration
reorientating1473765reor_ientating
repetition1278235rep___e_tition
replantations1544865rep__lantations
reprehensions1853195reprehen__sions
represent11410075represen__t___
represented1444115represen__t_ed
representer1353615represen__t_er
representers1452775represen__ters
represents1246755represen__t__s
repression1249045repres____sion
repristinations17193925repristinations
reprobation1548505repr___obation
reputation12411885rep____utation
reregistration1583135re_registration
reregulation1346415re_re_gulation
reservation1489145___reservation
restation9316915___res__tation
resuscitation1554295re_suscitation
revegetations17114715re_vege_tations
reverberation1893885reverbe_ration
sedimentation1654835se_dimentation
segmentation1556005se__gmentation
superfetation1855225superfe_tation
superstation14168625supers__tation
supplementation2171895supplementation

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 Filter178691950240.343520965.0
2DLD Change Limit95024916.86013851.9
3Display Results91910.0631444.4
 (SQL Overall)178691917.26624592.8
 
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.